Access 2007 Connection String

[mwulfe]

I want to use ADO with VB6 to connect to an Access 2007 database. Can
anyone tell me the provider text and the rest of the connection string
to use?

TIA,
Martin

 

[Douglas J. Steele]

http://www.connectionstrings.com/?carrier=access2007

 

[boblarson]

Just remember though, that if you are using ADO to connect to the CURRENT
database (not an external db) then you should be using
CurrentProject.Connection as the connection and not a normal ADO connection
string.

So, in other words you just use:

rst.Open "YourTableOrQuery", CurrentProject.Connection ...etc.


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________