MS Access Strings

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;"