In access 97 I could Dim As Database. Access 2002 doesn't have that
option : ( What do I do instead?

"gn" <gn (AT) hotmail (DOT) com> wrote

AC2002 uses ADO as the Default data access method. If you want to use DAO (like AC97), in the VBA IDE,
open the VBA Code Window, go to Tools>References and add a reference to "Microsoft DAO 3.x Data Access
Library". If you don't intend to use ADO, Uncheck the reference to "Microsoft ActiveX Data Objects 2.x
Library" to avoid Object Contention in your code. Just to avoid problems, you should also get used to
and adhere to declaring your database objects like this:

Dim Db as DAO.Database

NOT

Dim Db as Database

The Same DAO reference should Prepend all your database objects...