Access
      · ODBC
      o 标准连接(Standard Security):
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
      o 组(系统数据库)连接 (Workgroup):
      两种方法分别为:在连接串或在打开数据集中指定用户名和口令
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;","admin", ""
      或
      if(pDB.Open("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;", "", "DatabaseUser", "DatabasePass"))
      {DoSomething();
      pDB.Close();
      }
      o 独占方式(Exclusive):
      "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="
      · OLE DB, OleDbConnection (.NET)
      o 标准连接(Standard Security):
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"
      o 组连接 (系统数据库)
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;","admin", ""
      o 带口令的连接:
      "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;","admin", ""
posted @ 2005-06-06 10:47 S.Sams 阅读(989) 评论(0) 编辑