Access 2007 Connection String

  • Thread starter Thread starter mwulfe
  • Start date Start date
M

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
 
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

__________________________________
 
Back
Top