DAO compiler error

  • Thread starter Thread starter Suk9
  • Start date Start date
S

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
 
Suk9 said:
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?
Click to expand...


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.
 
Thank you very much, it worked!!!

Dirk Goldgar said:
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)
Click to expand...
 
Back
Top