DAO compiler error

[Suk9]

I have just created a new access database and wrote a module with line
Dim db As Database,
Access cannot compiler, how do I connect DAO to my database?
Regards

 

[Dirk Goldgar]

I have just created a new access database and wrote a module with line
Dim db As Database,
Access cannot compiler, how do I connect DAO to my database?

In the VB Editor, click Tools -> References..., locate Microsoft DAO 3.6
Object Library in the list, and put a check mark in the box next to it. If
you don't plan to use ADO (contrasted with DAO), remove the check mark next
to ActiveX Data Objects 2.x Library.

 

[Suk9]

Thank you very much, it worked!!!

In the VB Editor, click Tools -> References..., locate Microsoft DAO 3.6
Object Library in the list, and put a check mark in the box next to it. If
you don't plan to use ADO (contrasted with DAO), remove the check mark next
to ActiveX Data Objects 2.x Library.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)