Question about References

[ferryjenny]

Hi

I had a Access 97 database which I then converted to 2000 however when I went to use it on another machine I was getting an error message and it was not running.

I found that this was due to a missing library reference the database had the Microsoft visual basic for application extenibility 5.3 reference selected but I did not have that file on the computer which caused it not to run.

If i go to the database and deselect this reference then it runs fine.

I did not select this reference and wondered if anybody could explain how it ended up on my database, is it something that happens when you convert from 97 to 2000 or is it something that I have unwittingly done. I dont want it to happen again so any help would be gratefully received.

 

[Rolliee]

97's default is DAO and 2000 is ADO. That is the type of recordset with all its associated code. To remain compat... with 97 in 2000, you open a form and switch to the design mode. Then click Tools and you will see the reference list. Go done the list a loooong way and find MS DAO 3.6 or eq. I use 3.6 and it works well for me.

rollie@bwsys.net

 

[danvlas]

and...
Fully qualify Recordset, Database and Property object variables in Access 97 code as DAO:

Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim prp As DAO.Property

Otherwise they will be considered ADODB objects and you'll get errors and errors and errors...

Dan