DAO 3.6 Reference Keeps Moving down Ref List in Access 2003

[ISUTri]

I am currently running an update in MS Access 2003 of Access 2000
databases. For whatever reason every now and then the VBA Modules
reference list will automatically move the Microsoft DAO 3.6 to the
bottom of the reference list, breaking the updates. Can anyone tell me
why this is happening and what I can do to stop it? Other than typing
in DAO.(whatever) next to all of the objects?

Thanks for your help

 

[Douglas J. Steele]

Realistically, you should be typing DAO next to the declarations.

Disambiguation is always a good idea.

 

[Allen Browne]

I agree with Doug.

It's *really* easy to open any code window, and choose Replace on the Edit
menu to replace:
As Recordset
with:
As DAO.Recordset

As you find other problem declarations, you can then do them as well, e.g.
replace:
As Field
with As DAO.Field