Access设完密码后怎么连？

[haoren2002]

我编了个程序利用Access数据库，可设了密码后怎么再连上呀?

[chinchy]

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\test.mdb;Integrated Security=false;user id=Me; password=Mine;packet size=4096"

[孟子E章]

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

http://www.csdn.net/Develop/read_article.asp?id=16437

[孟子E章]

http://www.csdn.net/Develop/read_article.asp?id=16437

.NET中各种数据库连接大全