dyarosh
asked on
Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
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!!
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'
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!!
you need to install AccessDatabaseEngine.exe
question, did you try installing 64-bit version of Microsoft Access Database Engine components?
another thing you can try is installing 2007 components:
http://www.microsoft.com/en-us/download/details.aspx?id=23734
http://www.microsoft.com/en-us/download/details.aspx?id=23734
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will try installing the 2007 components. I have installed AccessDatabaseEngine.exe and I recompiled by app usin X86 CPU instead of Any CPU.
ASKER
I missed a setting when compiling as X86. I fixed it and now it works. Thanks.