Compile Error User defined type not defined

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NewTo2002 - 02 May 2005 10:19 GMT

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!

Reply to this Message

Tom Lake - 02 May 2005 11:06 GMT

> Hi,
>
[quoted text clipped - 5 lines]
>
> Why does this happen and what can I do about this?

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

Reply to this Message

NewTo2002 - 02 May 2005 11:46 GMT

That works.
Thanks a lot!

>> Hi,
>>
[quoted text clipped - 11 lines]
>
> Tom Lake

Reply to this Message