Missing object libraries- converting from Access 2003 to Access 97

G

Guest

I have some older Access 97 database files that I need to make some changes
to, and I need to keep them in Access 97 format.

I only have Access 2003, and in order to change them, I first have to
Convert Database to Access 2003 format, make changes, and then Convert
Database back to Access 97 format.

Conversion seems to work fine from 97 to 2003 format. But whenever I try to
convert back to 97 format, I get the following error:

COMPUTER IS MISSING AT LEAST ONE OF MICROSOFT ACCESS 97 OBJECT LIBRARIES.
YOUR CONVERTED DATABASE WILL NOT WORK UNTIL YOU OPEN THIS DATABASE USING
ACCESS 97 AND THEN FIX ANY MISSING REFERENCES.

Any help would be appreciated. Thanks.
 
G

Guest

Well, after much searching I found the solution...

Once the DB is converted to Access 2003, I went to
Tools->Macro->Visual Basic Editor

Once in the Visual Basic Editor, I went to
Tools->References
and I unchecked the reference that says
Microsoft DAO 3.6 Object Library
I then clicked OK, and closed the Visual Basic Editor.

Now when I Converted the DB back Access 97 format, there were no problems or
errors during the conversion, and this new DB works fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top