ADO Issue

[Sully38]

I am using Access 2002 on Windows XP

When trying to code the following ADO Code

Dim MYDB as Database ... Database is not a valid option to choose. I have coded this line in the past with Access without problem. Has this changed ? If so can this be added to my options or is there a new equivalent to it?

 

[Dugantrain]

This is actually DAO code, not ADO code. What you need to do is to open a Module, go to Tools, References, and set a Reference to the DAO 3.51 (or above) library. Because the Object Models are so similar, you'll either want to move this Reference in priority above the ADO reference or remove the ADO reference completely.

 

[Sully38]

Your fix worked like a charm, you are indeed and Access Guru.. May I ask what the ADO equivalent would be to dim as database?

 

[Dugantrain]

It's been a few months since I've worked with ADO (DAO is just so much simpler), but I seem to remember that in ADO you have a Connection String property:

dim conn as ADODB.Connection
conn.ConnectionString=CurrentProject.Connection

*edit* actually, I think that conn is an object that you'd need to set first:

dim conn as ADODB.Connection
Set conn=new ADODB.Connection