Introduction
While working with Microsoft Access database connectivity with ADO.NET, you may have received this error:
- The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
- The 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine
In this blog post, I will show you how to fix this kind of error.
This is a typical problem when you run Visual Studio projects like Visual Basic and Visual C#. It may be solved typically after you modify the C.P.U. to x86 rather than any C.P.U. Otherwise, the associated installation of bound components solves the matter.
Here is the list of solutions to this error. Just try the subsequent solutions one by one until you fix the problem. If one answer /solution doesn’t solve the matter, proceed to answer /solution two and so on.
Solution 1
Under the Project Properties, modify the target C.P.U. from AnyCPU to x86 as shown in the image above.
Solution 2
Download 2007 office System Driver: information connectivity elements.
Solution 3
Download Microsoft Access database Engine 2010 Redistributable.