Fixed - The 'Microsoft.ACE.OLEDB.12.0' Provider Is Not Registered On The Local Machine

watch_later 23 January, 2019
comment 4 Comments

Introduction


This article gives an explanation about how to resolve error The 'Microsoft.ACE.OLEDB.12.0' Provider Is Not Registered On The Local Machine or The 'Microsoft.Jet.oledb.4.0' Provider is not registered on the local machine.
The 'Microsoft.ACE.OLEDB.12.0' Provider Is Not Registered On The Local Machine
The 'Microsoft.ACE.OLEDB.12.0' Provider Is Not Registered On The Local Machine


Generally, this type of error comes while you working with Microsoft Access database connectivity with ADO.NET or when you work with Desktop applications which read from and write to various files formats including Excel, CSV, Access, Text files etc at that time you may have received following errors.
  1. The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
  2. The 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine
This is a very typical issue when you run your projects that are written in Visual Basic and Visual C# in Visual Studio version 2010, 2012, 2015,......,2019 and etc and It may be solved typically when you modify the AnyCPU to x86 rather than AnyCPU as I show in the screen.

Here I will show you how you can resolve these types of errors in easy steps and gives you the list of solutions to fix/resolve these types of errors. You Just try the subsequent solutions as I show you in this article and one by one until you fix the issue.

Solution 1: Change Target CPU from "Any CPU" to x86.

If you go with this solution then you should change Target CPU from "Any CPU" to x86 for your application and for that you can follow some steps as I shown below.

Step 1: Open your project in visual studio and press mouse right click on your project name from solution explorer.

Change Target CPU from Any CPU to x86

Step 2: Now, click on the property.


Step 3: You can see the following window on your screen, and now click on "Build" from left penal and change platform target from AnyCPU to x86.

Change Platform Target From AnyCPU to x86

Step 4: Save all the created settings and for that, you can press Ctrl +S and rebuild your project and run the project. 


If you go with this solution then you should Download 2007 office System Driver / Access Database Engine and install in your system.

If you go with this solution then you need to download the Microsoft Access Database Engine 2010 Redistributable and install in your system.
NOTE: If you transferring data Excel workbook into SQL Server or from SQL Server to Excel workbook either using SQL Server Import and Export Wizard or using C# or VB.net then you should go with Solution 3 that might resolve your error.

Summary


This article explains how to fix error The 'Microsoft.ACE.OLEDB.12.0' Provider Is Not Registered On The Local Machine and The 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine with very easy solutions.

Codingvila provides articles and blogs on web and software development for beginners as well as free Academic projects for final year students in Asp.Net, MVC, C#, Vb.Net, SQL Server, Angular Js, Android, PHP, Java, Python, Desktop Software Application and etc.

avatar

Does it mean that I can't work with 64 bit? I want 64 bit program with C#. Windows 10 and office 2016. Visual studio 2019. Please, anybody answer me.

delete September 3, 2019 at 7:05 AM
avatar
Codingvila person

Hi Giovanni Rodrigo, there is no need to change platform target from AnyCPU or 64 to x86, you can go with other solutions Download office System Driver based on your version of office from the internet or you can Download and Install Microsoft Access Database Engine Redistributable basen on your office version, still not get any solution then let me know.

delete September 3, 2019 at 7:45 AM
avatar

Hi, the build option is not in my properties, do you know why and/or is there any way I can still change the setting to any CPU?

delete June 17, 2020 at 9:42 PM
avatar
Codingvila person

Can I know witch version of visual studio do you have? If you can't see the build options in your property window, You can go with other solution like solution 2 or solution 3 as I explained in this article.

Still it not work for you you can contact me via ContactUS page or mail on info.codingvila@gmail.com i will find another solution for you.

delete June 17, 2020 at 11:31 PM

Thank you for your valuable time, to read this article, If you like this article, please share this article and post your valuable comments.

Once, you post your comment, we will review your posted comment and publish it. It may take a time around 24 business working hours.

Sometimes I not able to give detailed level explanation for your questions or comments, if you want detailed explanation, your can mansion your contact email id along with your question or you can do select given checkbox "Notify me" the time of write comment. So we can drop mail to you.

If you have any questions regarding this article/blog you can contact us on info.codingvila@gmail.com

sentiment_satisfied Emoticon