MS Access Strings
 

Check Out  http://www.dotnetUncle.com

Home

SQL 2000 Strings

SQL 2005 Strings

MS Access Strings

MySQL Strings

Oracle Strings

Notes on .NET

ODBC

Standard Security:

"Driver={Microsoft Access Driver (*.mdb)};
Dbq=C:\mydatabase.mdb;
Uid=Admin;
Pwd=;"


Workgroup:

"Driver={Microsoft Access Driver (*.mdb)};
Dbq=C:\mydatabase.mdb;
SystemDB=C:\mydatabase.mdw;"


Exclusive:

"Driver={Microsoft Access Driver (*.mdb)};
Dbq=C:\mydatabase.mdb;
Exclusive=1;Uid=admin;
Pwd="

 

OleDbConnection (.NET)


Standard security:

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\somepath\mydb.mdb;
User Id=admin;Password=;"


Workgroup (system database):

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\somepath\mydb.mdb;
Jet OLEDB:System Database=system.mdw;"

 

With password:

"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=\somepath\mydb.mdb;
Jet OLEDB:Database Password=MyDbPassword;"