连接 Access 2007 的操作方法

 

            //无密码的连接字符串

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

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

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

 

            //有密码的连接字符串

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

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

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

 

            连接 Access 2003 的操作方法

 

            //无密码的连接字符串

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

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

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

 

            //有密码的连接字符串

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

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

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

 

<connectionStrings>

<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;

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

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

</connectionStrings>

 

 

 

 

 

连接 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=数据库密码;

 

 

连接 Access 2007

<appSettings>

<add key="Access"

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

Data Source=E:\数据库\XiaoZhen.accdb;"/>   

</appSettings>

 

<connectionStrings>

<add name="Access"

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

Data Source=E:\数据库\XiaoZhen.accdb;" />

</connectionStrings>

 

 以上是总结的各种连接 Access 的连接字符串的一个总的汇总

转载于:https://www.cnblogs.com/cnzryblog/archive/2012/05/24/2516619.html