Why does Access lose references? [Resolved]

[dannymking]

you will need to disambiguate your references to DAO and ADO always use

Dim Db As DAO.Database
Dim Rc As DAO.Recordset
Dim Arc As ADODB.Recordset..

Also if using any of the other office apps like Excel or Word, switch it to Late binding instead of early binding..

If your database was built in A2K then be aware that some functionality was not available in A97, but it should not matter the other way round as A2K is backwards compatible.

The differences between machines will depend on the versions of DAO and ADO that the machine has installed, if possible ensure that the same version of these are available on all machines.

[salvelinus]

Thanks for the help. I'm not used to thinking of early/late binding, in VBA. For my sake, and others who don't know the difference, would you please give a few examples? I know that if you don't set a reference to DAO 3.6, for example, Intellisense doesn't pop up for that stuff. Apparently some users need it set & others don't. I've been doing it for all to make it uniform.
AFAIK, there's no ADO used, although I think A97 is DAO bt default, A2K is ADO by default. That might be one problem, if a 2K user gets into a 97 file. Hmmm...
Although sometimes the reference to normal stuff (Date(), e.g.) is lost.