getting error message for "Dim CurDB As Database"

[JumpinJimRivers]

Does anybody know why I get an error message saying "user-defined type not defined" for:

Dim CurDB As Database


Isn't "database" a pre-defined type and therefore suppose to be blue and also not to be giving me this stinking message? Well its black and it is giving me this message. WHY???

help!

 

[jhall156]

In the vba code window
Tools|References
select Microsoft DAO x.x
JHall

 

[JumpinJimRivers]

thank you very much.

...now i'm getting a "type mismatch" message for

Set dbs = CurrentDb

 

[jhall156]

Always declare your objects as their type. For example
Dim theDB as DAO.database
Set theDB= DBEngine(0)(0)

This will increase performance and ensure that you will catch any inappropriate method invocations or propert operations on your object. Early Binding vs. Late Binding JHall