Fixed - the microsoft.ace.oledb.12.0 provider is not registered on the local machine

watch_later 7/08/2024
comment 1 Comment
This article explains how to resolve the 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.

Fixed - 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 that read from and write to various file 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 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 a list of solutions to fix/determine 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 have shown below.

Step 1: Open your project in visual studio and press the mouse to 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 the left panel and change the 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, you should download the 2007 office System Driver / Access Database Engine and install it on your system.

If you go with this solution then you need to download the Microsoft Access Database Engine 2010 Redistributable and install it 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 errors 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.

Tags:


the microsoft.ace.oledb.12.0 provider is not registered on the local machine windows 10
the microsoft.ace.oledb.12.0 provider is not registered on the local machine windows 11
the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine. excel
how to register microsoft.ace.oledb.12.0 on local machine
how to check if microsoft ace oledb 12.0 is registered
microsoft.ace.oledb.12.0 download
the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine in ssis
the microsoft.ace.oledb.16.0 provider is not registered

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
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:00 PM GMT+5:30

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