Connection strings for Access

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=;
OLE DB, OleDbConnection (.NET)
  • 复制到剪贴板标准连接(Standard Security)
    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydb.mdb; User Id=admin;Password=;
  • 复制到剪贴板组连接/系统数据库(Workgroup/system database)
    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydb.mdb;Jet OLEDB:System Database=C:\system.mdw;
  • 复制到剪贴板带口令的连接
    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydb.mdb;Jet OLEDB:Database Password=MyPassword;

©2009 vhalpha#163.com 鲁ICP备09080449号