DB connection string
-
Can I use same DB connection string to connect to MS Access 2003 and MS Access 2007? I use this "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & databasePath.dbPath & ";Persist Security Info=False;"
Yes, it is possible to use the OLE DB provider for the Microsoft Office 12.0 Access Database Engine for both 2003 and 2007 versions of Access, although it is not possible to use the Jet 4.0 OLE DB engine for Access 2007 databases. Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
-
Yes, it is possible to use the OLE DB provider for the Microsoft Office 12.0 Access Database Engine for both 2003 and 2007 versions of Access, although it is not possible to use the Jet 4.0 OLE DB engine for Access 2007 databases. Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman