Compile Error User defined type not defined

Compile Error User defined type not defined

Post by NewTo200 » Tue, 03 May 2005 18:19:47


Hi,

This works fine in Access 97:
Dim db As Database
But in Access 2002 I get an error: Compile Error User defined type not
defined.
It does work in a database that is converted from 97 to 2002.

Why does this happen and what can I do about this?

Thanks!
 
 
 

Compile Error User defined type not defined

Post by Tom Lak » Tue, 03 May 2005 19:06:09


Try adding the Reference to the Microsoft DAO 3.6 library. To do that, edit
any module and click on Tools, then References. If the DAO library isn't
checked, check it.

Tom Lake

 
 
 

Compile Error User defined type not defined

Post by NewTo200 » Tue, 03 May 2005 19:46:41

That works.
Thanks a lot!