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

watch_later Wednesday, January 23, 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 2, 2019 at 6:35 PM
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 2, 2019 at 7:15 PM
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:12 AM
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:01 AM



sentiment_satisfied Emoticon