DAO Connection

[database]

How do I establish a DAO connection to the Database?

 

[fzamora]

How do I establish a DAO connection to the Database?

What are you trying to do? Are you trying to code this from within your database. If so

dim db as DAO.Database

set db = CurrentDb

 

[database]

I have tried doing that but it gives an error saying that User-defined type not defined... why is that so?

What are you trying to do? Are you trying to code this from within your database. If so

dim db as DAO.Database

set db = CurrentDb

 

[pono1]

I have tried doing that but it gives an error saying that User-defined type not defined...

Open your VBA window and from the pulldown menu select Tools- References. Scroll down Microsoft DAO 3.x Object Library and check the box next to it.

See the FAQ on this site for a detailed explanation.

Regards,
Tim

 

[database]

Well, It is currently set to Microsoft DAO 2.1 Library... does it make a difference?

Open your VBA window and from the pulldown menu select Tools- References. Scroll down Microsoft DAO 3.x Object Library and check the box next to it.

See the FAQ on this site for a detailed explanation.

Regards,
Tim

 

[dcx693]

That could be it. What version of Access are you running?

 

[Kodo]

are you sure it's DAO 2.1 and not ADO 2.1?

 

[dcx693]

are you sure it's DAO 2.1 and not ADO 2.1?

LOL! That's more likely the case here!

 

[Kodo]

you know MS and their rediculous obession with acronyms. Especially ones with the same letters in different order. oh wait.. I said MS..

 

[database]

Hey thanks all of you guys... I WAS confusing between DAO and ADO...