sql数据库连接，怎样改成access的连接呢？

Question

<configuration>
<appSettings/>
<connectionStrings>
    <add name="connstr" connectionString="server=.;database=sq_ncxhdata;uid=sa;pwd=sa;"/>
  </connectionStrings>
<system.web>
怎样改成access的连接呢？谢谢

Answer 1

connectionstring.com 
<add name="accessConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= |DataDirectory|a.mdb" providerName="System.Data.OleDb"/> <appSettings> 
<add key="ConnString" value="provider=microsoft.jet.oledb.4.0;data source="/> 
<add key="dbPath" value="~/App_Data/a.mdb"/> 
</appSettings>

Answer 2

</configSections>
  <connectionStrings>
    <add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\school.mdb" providerName="System.Data.OleDb" />
  </connectionStrings>