Missing reference

[dsoderstrom]

I have the following line in a module:
Dim dbsnightly As database
When I try to compile the module I get the message:
User defined type not defined.
When I click the help button, one of the paragraphs reads "Display th
References dialog box, and then select the appropriate object librar
or type library. For example, if you don't check the Data Access Objec
in the References dialog box, types like Database, Recordset, an
TableDef aren't recognized and references to them in code cause thi
error."
When I open the References dialog box I do not see "Data Access Object
listed. How do I find it?
(I am using Access 2002)

 

[Steve Schapel]

Dsoderstrom,

"Data Access Object" for your purposes, will be listed in the References
dialog as
"Microsoft DAO 3.6 Object Library"