Converting 97 to Access 2002 problem

[JennW]

My attempt to convert an Access 97 database to an Access 2002 database has resulted in an error stating that the database had not been saved in a compiled state. It also referenced a memory address error of all zeros.
In looking at Microsofts site I "think" I understand this problem to be something of a VB issue???

Is there a way of printing out exactly what Access 2002 doesnt like about this database and attempt to "debug" (for lack of a better term) each problem?

There has to be a better way of converting an Access 97 database then this and getting it to work?

I appreciate any help you can give.

JennW

 

[lameid]

I've only converted up to 97 myself but I assume compiling and all saving all modules is still the way to go... Open a module in design view and go to the debug menu.

 

[Databaseguy]

In the VBE, go to tools, references, and check the DAO 3.6 object. Go to Debug, Compile all modules, and fix the code as VBA highlights it. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy