Access 连接串

连接 Access 2007 的操作方法 //无密码的 连接 字符串 stringconStr = "Provider=Microsoft.Ace.OleDb.12.0;"; conStr += @"Data Source=E:\数据库\XiaoZhen.accdb;"; conStr += "Persist Security Info=False;"; //有密码的 连接 字符串 stringconStr = "Pr

连接 Access 2007 的操作方法

 

//无密码的连接字符串

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

conStr += @"Data Source=E:\数据库\XiaoZhen.accdb;";

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

 

//有密码的连接字符串

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

conStr += @"Data Source=E:\数据库\XiaoZhen.accdb;";

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

 

连接 Access 2003的操作方法

 

//无密码的连接字符串

stringconStr = "Provider=Microsoft.Jet.OleDb.4.0;";

conStr += @"Data Source=E:\数据库\XiaoZhen.mdb;";

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

 

//有密码的连接字符串

stringconStr = "Provider=Microsoft.Jet.OleDb.4.0;";

conStr += @"Data Source=E:\数据库\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"/>