App.config:<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
<add name="DefaultDatabase" connectionString="Provider=SQLOLEDB;Data Source = F:\Cool\PBF\PBF\EXE\PBF.accdb;" />
</connectionStrings>
</configuration>报错:无效的授权说明
注:数据库没有密码
<configuration>
<connectionStrings>
<add name="DefaultDatabase" connectionString="Provider=SQLOLEDB;Data Source = F:\Cool\PBF\PBF\EXE\PBF.accdb;" />
</connectionStrings>
</configuration>报错:无效的授权说明
注:数据库没有密码
Access数据库是.accdb文件,印象中好像是.mdb文件
Access 2007 是.accdb文件
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\laser.mdb;;Jet OLEDB:Database Password=1218;这是我最后生成的配置文件
<connectionStrings>
<add name="workData.Properties.Settings.laserConnectionString"
connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\laser.mdb;Jet OLEDB:Database Password=1218"
providerName="System.Data.OleDb" />
</connectionStrings>
string strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source=C:\Documents and Settings\v-changl\My Documents\Database1.accdb;";
strConnection += "Persist Security Info=False";
<configuration>
<connectionStrings>
<add name="DefaultDatabase" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source = F:\Cool\PBF\PBF\EXE\PBF.mdb;Jet OLEDB:Database Password=123456;" />
</connectionStrings>
<appSettings>
<add key="DatabaseCategory" value="Access"/>
</appSettings>
</configuration>把Access文件改成2003,就解决了,