How to Dim a Querydef or Database

[CarlitosWay]

Hello everyone,

I am a fairly new programmer and have run into what seems to be a silly problem. I have attempted to “Dim” several variables with Database and QueryDef in Access 2000. For some reason when I run the code it gives me the following error message “User defined type not defined”. I believe that it is referring to the Database and QueryDef. When I run the code in Access 97, it does not give me this error message. Am I missing something? Did I forget to load a library? Here is an example of code that is not working.


Dim dbsNorthwind As Database
Dim qdfTemp As QueryDef
Dim qdfNew As QueryDef


Thanks

 

[ToeShot]

In your VBA Editor go to TOOLS>REFERENCES then check and make sure you have MS DAO Jet 3.XX or 4.XX checked.

 

[Skeptik]

Hi!
try this:

Dim dbsNorthwind As dao.Database
Dim qdfTemp As dao.QueryDef
Dim qdfNew As dao.QueryDef

this should do the trick!

hope it works!

Skep

 

[Craig0201]

Should be ADO if using Access2K.

Craig