Visual Basic

View All Threads First Prev Next

DB connection string ivo752-Mar-12 18:36 ivo75 2-Mar-12 18:36  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;" Re: DB connection string Wayne Gaylard2-Mar-12 20:38 Wayne Gaylard 2-Mar-12 20:38  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 Re: DB connection string ivo753-Mar-12 8:17 ivo75 3-Mar-12 8:17  I want to connect without install Microsoft Office 12.0 Access Database Engine in the client mashine, because my program is 2MB, but Microsoft Office 12.0 Access Database Engine is 26MB. modified 3-Mar-12 14:29pm.

Last Visit: 31-Dec-99 18:00     Last Update: 12-May-24 17:10 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.