I am trying to use ADO to connect to a local database. I had it working earlier using the following line of code:

Set localConnection = CurrentProject.AccessConnection

But now when I am using this same code for a different database, VBA says that CurrentProject doesn't recognize this property for CurrentProject. Does anybody have any idea why VBA would start being so stubborn?

localConnection is my connection variable

I have it declared as follows:

Dim localConnection As New ADODB.Connection

AccessConnection is not available in Access 2000, try using Connection instead. You may be using Access version after 2000 but saving database in 2000 format.

--

Joe