Overview
This article provides you with examples of the connection strings used to connect to some common Access database data providers. It is worthy to note that each connection is different, therefore it is usually up to the server administrator to create and deploy the correct connection string for each application, user account, and type.
ODBC Provider
 Copy Code Standard Security |
|
|---|---|
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\myDataBaseFile.mdb;Uid=Admin;Pwd=;"
|
|
| Copy Code Workgroup |
|
|---|---|
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\myDataBaseFile.mdb;SystemDB=C:\myDataBaseFile.mdw;"
|
|
| Copy Code Exclusive |
|
|---|---|
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\myDataBaseFile.mdb;Exclusive=1;Uid=admin;Pwd="
|
|
OLE DB, OleDbConnection (.NET 2.0)
| Copy Code Standard Security |
|
|---|---|
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\myDataBasePath\myDataBaseFile.mdb;User Id=admin; Password=;" |
|
| Copy Code Workgroup (System Database) |
|
|---|---|
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\myDataBasePath\myDataBaseFile.mdb;Jet OLEDB: System Database=system.mdw;" |
|
| Copy Code Password Protected |
|
|---|---|
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\myDataBasePath\myDataBaseFile.mdb;Jet OLEDB: Database Password=MyDbPassword;" |
|