Microsoft Access Database Engine 2010 Redistributable
Back a few years ago, before Microsoft Office 2010, life was a little easier for developers: Office was 32-bit, period.
As you know our days just got a little more complicated since that with Microsoft Office 2010, users can also install a 64-bit native version of Office as well.
This means to us developers that our 32-bit applications using an OLEDB Provider to connect to Excel or Access files might not work anymore since the 32-bit provider might not exist on a 64-bit Office 2010 installation.
In such cases, even though the user has a valid installation of Microsoft Office 2010 installed on his machine, your application might get an error as:
The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine.
Well to address such problems Microsoft released a new redistributable named the “Microsoft Access Database Engine 2010 Redistributable”. This redistributable provides a 32-bit or a 64-bit version of the Microsoft ACE OLEDB Provider which can be downloaded here:
So if as a developer you have a 32-bit application using this OLEDB provider on a machine with a 64-bit installation of Office 2010 (such as the CodeFluent Entities Access Importer), you’ll need to install the 32-bit version of the provider.
Install Tip
Launching the install of a Microsoft ACE OLEDB Provider on a machine with an Office install other than the current one (e.g. 32 on 64) will cause the install to fail. To have it run properly you need to launch it from a command line with the “/passive” argument specified.
- To install the Microsoft ACE OLEDB Provider 32-bit on a machine running Office 2010 64-bit:
$> AccessDatabaseEngine.exe /passive
- To install the Microsoft ACE OLEDB Provider 64-bit on a machine running Office 2010 32-bit:
$> AccessDatabaseEngine_X64.exe /passive
Hope this helps,
Carl Anderson
Share this:
Leave a Reply Cancel reply
Search
Categories
- .NET (4)
- .NET Domain Model (36)
- ASP.NET (31)
- ASP.NET MVC (2)
- C# (3)
- Cache (1)
- Data access (1)
- Developing Using CodeFluent Entities (141)
- Documentation (10)
- Entity Framework (2)
- Exploring the CodeFluent Runtime (12)
- Importers (16)
- Links (9)
- MySQL (2)
- News (64)
- Not CodeFluent Related :) (19)
- Oracle Database (31)
- Pet Shop Reloaded (2)
- PostgreSQL (2)
- Presentation (63)
- Producers (5)
- ServiceStack (1)
- SharePoint (10)
- SoftFluent Products (16)
- SQL Server (44)
- SQLAzure (39)
- Templates (13)
- Tools (2)
- Uncategorized (2)
- WCF (10)
- Web API (2)
- WPF (10)
Recent Posts
- [Pet Shop Reloaded] The Application
- [Pet Shop Reloaded] A comparative study between CodeFluent Entities and Entity Framework
- Using flags enumeration with ASP.NET MVC and CodeFluent Entities
- Defining type mappers when importing a database using the Importer Wizard
- Creating a custom sub producer to only generate resources
Top Posts
Top Rated
Archives
- June 2013 (2)
- May 2013 (5)
- April 2013 (6)
- March 2013 (5)
- February 2013 (4)
- January 2013 (1)
- December 2012 (3)
- November 2012 (8)
- October 2012 (8)
- September 2012 (4)
- August 2012 (7)
- July 2012 (8)
- June 2012 (11)
- May 2012 (4)
- April 2012 (11)
- March 2012 (11)
- February 2012 (12)
- January 2012 (14)
- December 2011 (12)
- November 2011 (16)
- October 2011 (5)
- September 2011 (16)
- August 2011 (15)
- June 2011 (22)
- May 2011 (16)
- April 2011 (11)
- March 2011 (16)
- February 2011 (16)
- January 2011 (14)
- December 2010 (1)
- November 2010 (9)
- October 2010 (1)
- September 2010 (1)
- July 2010 (2)
- June 2010 (2)
- May 2010 (1)
- April 2010 (1)
- March 2010 (2)
- February 2010 (1)
- January 2010 (4)
- December 2009 (5)
- November 2009 (1)
- August 2009 (1)
- July 2009 (1)
- June 2009 (2)
“/passive” helps to install ADE x32 on computer with Office x64, but then it crashes on usage (access violation). Any hints? Did anyone succeed with this “install tip”?
Hi,
We installed the component on several machines using this trick without bumping into your problem. You can also find other users using the same trick successfully (see Andreas Marschall’s comment on this post: http://blogs.msdn.com/b/farukcelik/archive/2010/06/04/accessing-excel-files-on-a-x64-machine.aspx).
Carl
Thanks for this excellent tip !
Thanks, the /passive switch worked on our Server 2008 64-bit machine with Office 2007 32-bit. Complaint window gone and 3rd party app functions with OLEDB connection to Excel.
This post made my day, Thanks
Thanks. This saved my butt for our Computer Science Lab. Windows 7 64bit running Office 2010 32bit.
Needed to run the 64bit version to get the drivers to show up.
This was really helpful, until I tried to open any of the Office programs, at which point a setup window popped up and (presumably) overwrote the passively-installed 64-bit version. After this, I could not run my 64-bit application (popups telling me it couldn’t load the approriate libraries) until I re-installed the 64-bit engine (passively).
Is there any way to change this behavior? I’d hate to tell my clients that they have to re-install this every time they want to use my software.
Awesome tip… was looking for a workaroung to install the X64 engine without having to uninstall the 32 bit office….
I am having the same issue – the installation in /passive mode works, but right after I got the error on any Office program, claiming of missing libraries. After it, nothing helps – just to reinstall the Office.
Any ideas?
I’ve found that, on a clean mchine, if I install AccessDatabaseEngine.exe and then install AccessDatabaseEngine_x64.exe /passive, my 64-bit ADO (C++) program works. But if I do the reverse, install AccessDatabaseEngine_x64.exe and then install AccessDatabaseEngine.exe /passive, my program now reports “Module not found”. The problem can only be fixed by uninstalling both and starting over.
Well, I installaed the AccessDatabaseEngine (2010 32 bit version first) then installed the 64 bit version (with /passive) but both Word and Excel keep complaining about missing files. You can click OK then Cancel, but have to do it everytime you start Excel or Word.
MS Access 2010 (32 bit) doesn’t run at all anymore (only when the 64 bit driver is removed).
Hi, seems you had the same problems, have you been able to fix it? I cannot find the uninstall for the x64 Engine =( guess, the passive switch doesn’t leaved any uninstall information.
Well, I have a win2k8 r2 server with 32 bit office 2010 and used the /passive switch on the accessdatabaseengine_x64. Install was fine, no errors, but now my access is broken and cannot be started anymore, Word is also complaining on startup.
Any of you had these problems as well and even know how to fix it??
Thanks!
this is a life saver i’ve been at this issue for hours…….i have windows 7 64 bit with office 2010 32 bit i was able to make it work when i changed the platform target to x86 from any CPU but that cropped up other issues from different dlls……i was at my wits end…….thanks a ton…….
SoftFluent,
I really want to thank, I spend so many time to find tips you gave (AccessDatabaseEngine_X64.exe /passive)
Abdel
I haven’t tried this yet, but will do soon…I want to avoid another trip to the trichologist!
Paul Harrold Microsoft Access developer
If only Google were as smart as you were, I would have found this post hours ago. Thank you so much, you’re a lifesaver.
It works, thnx!!
Thanks it worked for me, but Facing strange problem with this component.
It gets uninstalled automatically almost every time the server reboots!!
Any help please…
I agree with KrazeeBob! I was searching for this solution for HOURS! Maybe a few DAYS actually! Thank you so much!
Thank you very much worked for me so I can say that this correction solves problems
Wow!, Thank you So much!
A year i spend, you have the solution. I’ve run \windows\syswow64\odbcad32.exe but not work. office 2007 (32bit) on win7 x64
In my case I am running:
- Windows Server 2008 R2 x64
- SQL Server 2008 R2 x64
- MS Office 2010 x86
I had to install the x86 version of the Microsoft Access Database Engine 2010 because it detected that MS Office was x86. I am not trying to query excel; rather, a sharepoint list. I have a similar setup on another box without office and it works great. On this box and one other I constantly get the following error and both have Office x86 on them:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider “Microsoft.ACE.OLEDB.12.0″ for linked server “(null)” reported an error. Access denied.
I have also tried to install the 2007 Office System Driver: Data Connectivity Components which was mentioned in another post but that did not resolve my problem. I have verified that Ad-Hoc Queries is enabled and have ran the following with no luck:
USE [master]
GO
EXEC master.dbo.sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’AllowInProcess’ , 1
GO
EXEC master.dbo.sp_MSset_oledb_prop N’Microsoft.ACE.OLEDB.12.0′ , N’DynamicParameters’ , 1
GO
I have compared the registry settings between the known working system and these and they seem identical in terms of the provider info; however, I am unable to see the Microsoft.ACE.OLEDB.12.0 provider listed within the Linked Server providers so this gives me a feeling that Office specifically Access and the Microsoft.Jet.OLEDB.4.0 are conflicting here. I am not positive on this but I just have a feeling that this is causing my pain.
Yes, this really does help! Many thanks
Super! It works like a charm!
Fantastic, you saved my day.
excellent it works for me
Thanks this solution! I went so far as to uninstall office 2003, office 2010, visio 2003, et. al., and the x64 it still wouldn’t load. So many things got screwed up it was easier to restore the entire partition than try and sort it all out. On the downside, I lost this link in the process, but at least I knew there was a solution out there… Will be testing later this evening. Thanks again!
Tested the system and all my 32 bit MS Offices apps pop up a “Configuring MS Office pro 2010″ window. The window closes after 30 secs or so, but is incredibly annoying. Any Advice?
Found this solution posted by “Applied Maths NV” at this link:
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/abf34eea-1029-429a-b88e-4671bffcee76/
I have pasted below the text of the portion of the link that resolved my problem:
“Here’s a workaround for installing the 64-bit version of the Microsoft Access Database Engine 2010 redistributable on a system with a 32-bit MS Office version installed:
Check the 64-bit registry key “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths” before installing the 64-bit version of the Microsoft Access Database Engine 2010 redistributable.
If it does not contain the “mso.dll” registry value, then you will need to rename or delete the value after installing the 64-bit version of the Microsoft Access Database Engine 2010 redistributable on a system with a 32-bit version of MS Office installed.
Use the “/passive” command line parameter to install the redistributable, e.g. “C:\directory path\AccessDatabaseEngine_x64.exe” /passive Delete or rename the “mso.dll” registry value, which contains the path to the 64-bit version of MSO.DLL (and should not be used by 32-bit MS Office versions).
Now you can start a 32-bit MS Office application without the “re-configuring” issue. Note that the “mso.dll” registry value will already be present if a 64-bit version of MS Office is installed. In this case the value should not be deleted or renamed.”
Many thanks to you all and “Applied Maths NV”.