Converting a database from 97 to 2002

[dakota81]

I needed this upgrade for compatibility with a dual monitor setup, 97 does not work well when being on the right monitor, combo boxes display not on the right, but rather the left monitor, go fig.

So I've run into errors trying to convert the database to 2002. In 97 the application and all forms work without error, all compile, all run smoothly. The conversion errors table created by 2002 that supposidly tells me:

Object Type: Module
Object Name:
Error Description: There were compilation errors during the conversion or enabling of this database.

I had one module that just held public variables so that I could transfer more information to a form when opening it.

Okay, so I deleted the module (had to go to a computer with 97 to do so), and the stupid program still won't convert the database, showing the same error.

And personally, I don't know why people would be upgrading this program ever, except for specific cases like mine, 2002 accomplishes the same tasks, just has a different look to it.

Any help on the conversion?

 

[Databaseguy]

I don't know 2002. I'll assume it uses ADO like 2000. If that is the case, you'll have to convert all of your code to be compliant with ADO. Or, in a Module, go to tools, references, and check the DAO 3.X check box.

As far as modules, if you have any forms with command buttons, macros, reports with on open events, etc, these are are all modules.

 

[Databaseguy]

P.S.

Just go into any code window, and hit Complie All Modules Now. It'll hang and highlight all the errors one by one.