2000 to 97, Please Help

[philljp390]

I just converted a database into Access 97 from 2000 and its giving me an error in the code on this:

Dim dbNm As Database

It says the project or library is missing.

How can i fix this?

 

[maxmangion]

when you are in the vba editor go to tools -> References and select your missing reference from there!

 

[philljp390]

yes, i checked the references and two of them say "MISSING" next to them, does this mean Access 97 needs these 2 libraries installed on the computer? and is it possible to do that?

 

[maxmangion]

I just converted a database into Access 97 from 2000 and its giving me an error in the code on this:

Dim dbNm As Database

You need to place a check near "Microsoft DAO 3.6" in the reference list to get that to work!

 

[philljp390]

ok, it was saying:

MISSING: Microsoft DAO 3.5

So i scrolled down and saw

Microsoft DAO 2.5

so i selected that and its now working.

 

[maxmangion]

yes it could be the DAO 2.5 ... i said 3.6 because i'm using A2K and i wasn't sure if Access 97 used that or an earlier one! Good to hear that your problem is sorted now!