access数据库连接

Access
ODBC

Standard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"

Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;","admin", ""

OLEDB, OleDbConnection (.NET)

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

Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""

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

string connectstring = @"Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=d:\user\usefortest.mdb;User Id=admin;Password=;" ;
OleDbConnection con = new OleDbConnection(connectstring);

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;DATA
source=d:\\mytable.mdb";

OleDbConnection dbconn=new OleDbConnection(strConnection);