Cannot open ADO connection to Access 2007 accdb

[Marcia]

Hi,

I am trying to convert a VBA project written in Access 2003 to Access 2007.
I have converted all of the mdbs involved to accdb format. Now, when the
code to relink tables using ADOX or open tables as recordsets using ADO runs,
it fails with the error, "Unrecognized database format". I have updated the
ADO and ADOX references to the latest version, which appears to be 6.0. (I am
running this on Vista, BTW.) Previously, it was using 2.8. Neither
reference results in success. Is it the case that ADO/ADOX do not currently
work in Access 2007? Or is there a setting I can change that will result in
a successful connection?

Thanks,
Marcia

 

[Douglas J. Steele]

Are you creating your own Connection object, or simply using the
CurrentProject.Connection one?

If you're creating your own, what connection string are you specifying?

 

[RoyVidar]

Hi,

I am trying to convert a VBA project written in Access 2003 to Access 2007.
I have converted all of the mdbs involved to accdb format. Now, when the
code to relink tables using ADOX or open tables as recordsets using ADO runs,
it fails with the error, "Unrecognized database format". I have updated the
ADO and ADOX references to the latest version, which appears to be 6.0. (I am
running this on Vista, BTW.) Previously, it was using 2.8. Neither
reference results in success. Is it the case that ADO/ADOX do not currently
work in Access 2007? Or is there a setting I can change that will result in
a successful connection?

Thanks,
Marcia

Check out the connection string
http://www.connectionstrings.com/?carrier=access2007

 

[Marcia]

Hi Doug,

I am using a connection string that connects to the backend database file:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyData\MyData.accdb

Thanks,
Marcia

 

[Douglas J. Steele]

That's for MDBs: for ACCDBs, you need to use

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\MyData\MyData.accdb;Persist
Security Info=False;

 

[Marcia]

Doug,

Thank you so much for this information. I read several articles on MSDN
about "the new file format in Access 2007" before finally giving up and
posting here. Are there any technical articles for developers on MSDN where
I could have found this information?

Thanks,
Marcia

 

[Douglas J. Steele]

Jeff Conrad has a good site specific to Access 2007 at
http://accessjunkie.com/default.aspx

He also links to other good Access 2007 sites.

 

[Marcia]

Thanks very much!

Jeff Conrad has a good site specific to Access 2007 at
http://accessjunkie.com/default.aspx

He also links to other good Access 2007 sites.