Database Data type

[Sue]

I'm trying to define a database object so that I can use
the CurrentDB method but the statments:
Dim dbs As Database
or
Dim dbs As DAO.Database
both return the error 'User-defined data type not defined'
and this type isn't listed in the autocomplete listbox
that comes up when you type 'As '.

Thanks,

Sue (pulling-hair-out)

 

[Allen Browne]

From any code window, choose References from the Tools menu.
Check the box beside:
Microsoft DAO 3.6

More info on references:
http://allenbrowne.com/ser-38.html

 

[Sue]

Wow! So simple, yet so effective. Thanks muchly!
For future reference, where should I have been able to
find out this kind of information?
Sue

 

[Allen Browne]

In an ideal world, Sue, you should not have to know this kind of
information. That was the case until Access 2000, when Microsoft suddenly
disabled this library after having it faithfully in the previous 5 versions.
Fortunately they put the reference back in by default in A2003.

Now you are aware of the references issue, you will know to look at which
library provides the reference. The Help file does show the various trees.
The Object Browser also helps locate objects (F2 from a code window). Since
the DAO library is so useful in Access (JET) databases, there is a picture
of the library in this link also:
http://allenbrowne.com/ser-04.html