Dim Db as Database

[aojonesoa]

I wrote a pretty intense application in Access 97 that contain several lookups based on the Database object. When I tried to run the application in Access 2000, it comes up with a compile error in all forms that have lookups referencing the Database object.

What am I to do?

One thing to note is that the Tools-Database Utilities-Convert Database was "grayed out". So I had to start a new Access 2000 database and import everything into it. Fortunately, I still have a copy of the old database if I need it.

 

[TheInsider]

Did you check to ensure that all of your Referrences are there and that you have chosen DAO 3.51 or 3.6? Rob Marriott
rob@career-connections.net

 

[aojonesoa]

Uh, what? All references should be there, I simply imported all tables, queries, forms, reports, macros and modules from my old database that still works (on the same PC).

As far as DAO 3.51 or 3.6, I don't know how to check that. Is it possible I have both installed, one used by Access 97 and the other one used by Access 2000?