'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine
I am using Access 2010 accdb database and wants to connect a C# program using the oledb provider 'Microsoft.ACE.OLEDB.14.0' but it does not seem to work as I get this error.
The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local
What am I doing wrong?
There is no provider named 'Microsoft.ACE.OLEDB.14.0' even though it's Access 2010 (aka version number 14) the provider that should be used still is named with version number 12.
So change from 'Microsoft.ACE.OLEDB.14.0' to 'Microsoft.ACE.OLEDB.12.0' and it will probably work better!
That's the solution!!