Dim As Database

[gn]

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

[Wayne Gillespie]

On Wed, 19 May 2004 21:24:00 -0500, gn <[e-mail]> wrote:

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

You need to set a reference to the DAO 3.6 library
By default Access 2000 uses ADO and does not have a reference to DAO set in a new db.

Open any standard module and on the Tools menu, select References. If you are not going to use ADO, uncheck the Active X
Data Objects (ADO) reference and select the DAO 3.6 option instead.

If you are going to use ADO and also want to use DAO, select both options but you must then explicitely declare the
library when you set objects as both libraries contain objects with the same name eg Recordset -
Dim rst as DAO.Recordset
Dim rst as ADO.Recordset
Wayne Gillespie
Gosford NSW Australia