Coverting Access 2.0 to Access 2003

[netchie]

Hi,

I need to convert Access databases with version 2.0 to 2003. I've heard that before you convert them, you need to compile them first. Is this true? If yes, how can I compile it?



Thanks,
netchie

[June7]

Appears that is correct. Review http://office.microsoft.com/en-us/ac...005186378.aspx

[netchie]

Hi June7,

Thanks for immediate reply but I am already having a problem when trying to compile it. it says:

1. Open a module
2. In Access 2.0, on the Run menu, click Compile Loaded Modules.

The problem is the module of my databae Access 2.0 is blank. There's nothing to click so the "Run" button is not clickable that's why I couldn't compile it.

Please help????

[June7]

I started with Access 2003 so don't really know how this conversion works. Not sure what 'Open a module in Design view' means. Maybe open the VBA editor?

Do you have any VBA code behind the db? Behind a form? A button Click event? If there is absolutely no VBA then maybe the compile step is not needed. Continue with steps 2 and 3.

I hope you are doing this with a copy of the original db.

[netchie]

I converted it to 2003 without compiling and I got a bunch of errors:

1. Sub Form_Load ()

DoCmd RunSQL "INSERT INTO [BAMtblUserLog] ([DB],[Login],[User]) VALUES ('Amend',Now(),CurrentUser());"
End Sub

and

2. Sub Form_Unload (Cancel As Integer)
DoCmd RunSQL "UPDATE [BAMtblUserLog] SET [Logout] = Now() WHERE [DB] = 'Amend' AND [User] = CurrentUser() AND IsNull([Logout])"
End Sub

So since I can't compile it and just do Step 2 and 3 that I'm going to get a bunch of errors??

And yes, I am only converting a copy not the original

[June7]

There were VBA procedures then should be able to do the compile. I don't know how Access 2.0 presents the VBA editor, but simply go to one of the procedures, click cursor in procedure, is the Run>Compile now available?

A bunch of errors? You show two, are those just representative and there are more?

Looks like the error is missing dot (.) - DoCmd.RunSQL
If that is all, maybe just do a search/replace on the string to fix.

Then run Compile and Compact & Repair from 2003 or 2007. Everything fixed?