Access連接字符串全集

連接 Access 2007 的操作方法 //無密碼的連接字符串 string conStr = "Provider=Microsoft.Ace.OleDb.12.0;"; conStr += @"Data Source=E:\數(shù)據(jù)庫\XiaoZhen.accdb;"; conStr += "Persist Security Info=False;"; //有密碼的連接字符串 string conStr = "Prov

連接 Access 2007 的操作方法

//無密碼的連接字符串

string conStr = "Provider=Microsoft.Ace.OleDb.12.0;";

conStr += @"Data Source=E:\數(shù)據(jù)庫\XiaoZhen.accdb;";

conStr += "Persist Security Info=False;";

//有密碼的連接字符串

string conStr = "Provider=Microsoft.Ace.OleDb.12.0;";

conStr += @"Data Source=E:\數(shù)據(jù)庫\XiaoZhen.accdb;";

conStr += "Jet OleDb:DataBase Password='829321';";

連接 Access 2003 的操作方法

//無密碼的連接字符串

string conStr = "Provider=Microsoft.Jet.OleDb.4.0;";

conStr += @"Data Source=E:\數(shù)據(jù)庫\XiaoZhen.mdb;";

conStr += "Persist Security Info=False;";

//有密碼的連接字符串

string conStr = "Provider=Microsoft.Jet.OleDb.4.0;";

conStr += @"Data Source=E:\數(shù)據(jù)庫\XiaoZhen.mdb;";

conStr += "Jet OleDb:DataBase Password='829321';";

Data Source=F:\TeacherSystem\App_Data\db.mdb;

Jet OLEDB:Database Password=123" providerName="System.Data.OleDb" />

連接 Access 2003

Provider=Microsoft.Jet.OleDb.4.0;

Data Source=Access2007文件位置;

Persist Security Info=False;

連接 Access 2007

Provider=Microsoft.ACE.OLEDB.12.0;

Data Source=Access2007文件位置;

Persist Security Info=False;

連接 Access 2007

Provider=Microsoft.ACE.OLEDB.12.0;

Data Source=Excel2007文件位置;

Jet OLEDB:Database Password=數(shù)據(jù)庫密碼;

連接 Access 2007

value="Provider=Microsoft.Ace.OleDb.12.0;

Data Source=E:\數(shù)據(jù)庫\XiaoZhen.accdb;"/>

connectionString="Provider=Microsoft.Ace.OleDb.12.0;

Data Source=E:\數(shù)據(jù)庫\XiaoZhen.accdb;" />

以上是總結(jié)的各種連接 Access 的連接字符串的一個總的匯總

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com