DA0 in Access 2000

[jrh1]

I converted an Access 97 database to Access 2000. My DA0 works find in this converted database.

However, when I export the DA0 to a non-converted database, it does not run!!!

My Access exe is the same for both databases, and I have references set to DA0 3.6.

Any help would be greatly appreciated.

Thanks,
jeff

 

[jebry]

Hi Jeff!

Perhaps it is the relative positions of the DAO and ADO references in the two databases that is causing the problem. If the object library is not specified in the Dim statement then Access will assume that the library it is to use is the first it encounters on the list. So, if you want DAO to be the default library, you need to move the DAO reference up the list until it is higher than the ADO reference. It is better to just be specific when the objects are declared.

hth


Jeff Bridgham
bridgham@purdue.edu