Database Object

[RB]

I have the following line of code in an Access2000
database:

Dim dbRobin as Database

I keep getting the following error and don't understand
why...

Compile error
User-defined type not defined

 

[Van T. Dinh]

Open any code module and use the Menu Tools / References ...
and add the Microsoft Data Access Object (DAO) 3.6 Library into the
References Collection of your database.

If you are not using ADO, also remove the ADO Library from the References by
unchecking it.

 

[Elwin]

Database is a DAO object. You probably need to set a
reference to the DAO library.

Dim dbRobin as DAO.Database

Select Tools | References from the code screen menu bar.
Scroll down and check the Microsoft DAO 3.6 Object Library
Click OK and recompile.