Database as User-Defined Type

[JoeMarfice]

Database as User-Defined Type

Ick!

I haven't programmed in Access for a LONG time, and I'm feeling foolish.

When I use the following declaration:
Dim db As Database
I receive the following error message:

Compile error
User-defined type not defined.

What is going on here? Obviously, Database is not a user-defined type.

 

[DBL]

You could be missing a reference. Open a module and go to Tools>References. See if any of them are marked as Missing and if they are, tick the box, then try to compile it again. It might be Microsoft DAO 3.6 reference library that's missing (if it's A2K, I think it's either 3.5 or 2.5 compatible in 97)

 

[Nero]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=34755