Converting from 97 to 2003 (version 2003)

Topic

New Reply

I am in the process of converting 97 databases to 2003. I got an error message on the very first one. Lucky me!

The conversion seemed to go flawless until I was ready to open the database. I am using a switchboard and I get an error message when try to load it. The de###### stops at the set dbs = currentDb () code. I went through my references and actived all the necessary ones but I must have missed something. It still tells me error in loading DLL.

Any help would be appreciated.

Deborah

Reply | Quote

Replies

Hi Deborah

Have you referenced the Microsoft DAO x.x Library? Also, make sure the reference to this library is moved as far up the list of reference libraries as it will go. You could try – Dim dbs As DAO.Database

Just some ideas.

Reply | Quote

Specifically make sure that the references to DAO is higher in the list than the reference to ADO.

In 97 any declaration such as Dim db as database meant a DAO.Database.
In 2000 (or later) it could be either DAO.database or ADO.Database.

To be safe each declaration should say Dim db as DAO.database

but the default is the first in the list of references. So putting DAO higher than ADO should fix it.

Reply | Quote