This project has moved. For the latest updates, please go here.

SOLVED & FYI: Provider and Connection configuration (Web.config)

Sep 4, 2016 at 5:11 PM
For those who are looking for a working config settings for this. Hope this helps.
 <connectionStrings>
    <add name="MyEntities" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\MyAccessDb.mdb" providerName="JetEntityFrameworkProvider" />
    <add name="MyEntities" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source==|DataDirectory|\MyAccessDb.accdb;Persist Security Info=True" providerName="JetEntityFrameworkProvider" />
  </connectionStrings>

  <system.data>
    <DbProviderFactories>
      <remove invariant="JetEntityFrameworkProvider"/>
      <add invariant="JetEntityFrameworkProvider" name="Jet Entity Framework Provider" description="Jet Entity Framework Provider" type="JetEntityFrameworkProvider.JetProviderFactory, JetEntityFrameworkProvider"/>
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <providers>
      <provider invariantName="JetEntityFrameworkProvider" type="JetEntityFrameworkProvider.JetProviderServices, JetEntityFrameworkProvider"/>
    </providers>
  </entityFramework>