Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Posted on 2012-09-06
7
Medium Priority
?
1,873 Views
Last Modified: 2012-09-11
I am getting the above error on an application after upgrading to Windows 7.  Here is what happened.

Had an older computer running Windows XP with MS Office 2010 installed on it.  This computer also had a custom program that was written in VS 2008 running on the computer that utilized an Access database.  The computer died and was replaced with a new computer that is running Windows 7.  I reinstalled the custom program successfully (i.e. no errors during install) however when the program is started and tries to connect to the database I get the error "Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine".

I have spent many hours searching google for the error and found a link to download the driver from the "Microsoft Access Database Engine 2010 Redistributable".  I downloaded and installed the 32 bit version of the driver because my version of Office 2010 is the 32 bit  version.  The install was successful (i.e. no errors during installation) however the error still exists when I run the custom program.

I installed the custom program on two other computers running Windows 7 but they had MS Office 2007 installed.  In both cases, the custom program installed and worked successfully.

I found another link that suggested recompiling my custom program specifically for an X86 CPU instead of Any CPU which is the default in VS 2008.  I did this and it still didn't work.

So based on what I have done so far, the problem seems to be with the combination of Windows 7 and MS Office 2010.  Can anyone please help me resolve this problem?  I have been working on this since Tuesday with no success!  I appreciate any and all help!!
0
Comment
Question by:dyarosh
  • 5
  • 2
7 Comments
 
LVL 35

Expert Comment

by:YZlat
ID: 38375929
you need to install AccessDatabaseEngine.exe
0
 
LVL 35

Expert Comment

by:YZlat
ID: 38375931
0
 
LVL 35

Expert Comment

by:YZlat
ID: 38375977
question, did you try  installing 64-bit version of Microsoft Access Database Engine components?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 35

Expert Comment

by:YZlat
ID: 38375983
another thing you can try is installing 2007 components:

http://www.microsoft.com/en-us/download/details.aspx?id=23734
0
 
LVL 35

Accepted Solution

by:
YZlat earned 2000 total points
ID: 38375991
0
 

Author Comment

by:dyarosh
ID: 38376045
I will try installing the 2007 components.  I have installed AccessDatabaseEngine.exe and I recompiled by app usin X86 CPU instead of Any CPU.
0
 

Author Closing Comment

by:dyarosh
ID: 38388489
I missed a setting when compiling as X86.  I fixed it and now it works.  Thanks.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Unable to change the program that handles the scan event from a network attached Canon/Brother printer/scanner. This means you'll always have to choose which program handles this action, e.g. ControlCenter4 (in the case of a Brother).
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question