I am trying to connect to a Access database. I have setup in advance a Access db called "ToAccess.mdb".
In Visual Studio 2013 I have setup in web.config this excerpt:
Code:
<connectionStrings>
<add name="Accessdb" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\a Access\ToAccess.mdb;Persist Security Info=False;" />
</connectionStrings>
In Server Explorer>Data Connections>Add Connection... I selected Data Source:
Microsoft Access Database File (OLE DB)
I selected my Access file: "C:\Users\User\Documents\a Access\ToAccess.mdb" and it came up on my Server Explorer. That was ok.
I am having an error with my connection string:
"System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. ".
Any suggestions?