Posted  by  admin

Microsoft Database Engine 2010 Download

Dec 16, 2010 Microsoft Access Database Engine 2010 Redistributable (64-bit) enables the transfer of data between existing Microsoft Office files such as Microsoft Office Access 2010 (.mdb and.accdb) files. Jul 01, 2016 In the list of currently installed programs, select “Microsoft Access database engine 2010” and then click Remove or Add/Remove. If a dialog box appears, follow the instructions to remove the program. Click Yes or OK to confirm that you want to remove the program.

The download version of Microsoft Access Database Engine 2010 Redistributable is 12.0.6787.5000. The software is periodically scanned by our antivirus system. We also encourage you to check the files with your own antivirus before launching the installation. Microsoft Access Database Engine 2010 Redistributable antivirus report. Download Microsoft Access Database Engine 2010 Redistributable (32-bit) for Windows to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications.

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”. Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center. Premium Office apps, extra cloud storage, advanced security, and more—all in one convenient subscription. (32-Bit x86), Windows Server 2003 R2 x64 editions, Windows Server 2008 R2, Windows Server 2008 Service Pack 2. 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 'HKEYLOCALMACHINESOFTWAREMicrosoftOffice14.0CommonFilesPaths' before installing the 64-bit version of the Microsoft Access Database Engine. Only the 32-bit Access Database Engine may be used on Windows XP Service Pack 3 Instructions Note: Before installing this download, you must first remove any previous versions of the Access Database Engine from your computer by using Add/Remove Programs in the Control Panel. The Access Database Engine 2010 Redistributable is not intended: As a general replacement for Jet (If you need a general replacement for Jet you should use SQL Server Express Edition ). As a replacement for the Jet OLEDB Provider in server-side applications.

We currently have a major issue using Microsoft Access Database Engine 2010. The engine comes in 64-bit and 32-bit forms, which is good. However, apparently you need to always install the 32-bit version if the host process is always 32-bit. Fine, we can do this.

Our software deals with a lot of legacy components that are 32-bit, and much of it is in VB6 code, which generates 32-bit assembly. So, we are under the assumption that the driver must also be installed as 32-bit. Indeed, when we install 32-bit drivers on a 64-bit machine, and run our 32-bit applications, it works correctly.

However, the problem begins when Office 2010 64-bit is installed on the system. Trust me, we've tried to educate users that 64-bit Office is largely unnecessary, to no avail. As computers come off the assembly line with 64-bit versions installed, we're unable to keep up with support requests when our software breaks something. Either the 64-bit Office breaks our installation, or our installation breaks their Office version, but it's not pretty either way. A further issue is that non-legacy software will sometimes install the 64-bit drivers (as they should), and the two versions simply do not coexist in any reasonable manner. Either our software breaks, or their software breaks.

So, has anybody managed to find a way to make the 32-bit drivers coexist with 64-bit installations? I have seen that installing with /passive flag allows the two to be installed, and our installer does use passive. Both are being installed, but once on the system either our software no longer works, or Office constantly repairs its installation. Is there any reasonable way to make this work?

drharris

Microsoft Access Database Engine 64-bit

drharris
9,9085 gold badges37 silver badges53 bronze badges

Microsoft Access Database Engine 2007 Redistributable

6 Answers

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_MACHINESOFTWAREMicrosoftOffice14.0CommonFilesPaths' 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 pathAccessDatabaseEngine_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.

Also if you do not want to use the '/passive' command line parameter you can edit the AceRedist.msi file to remove the MS Office architecture check:

  • download and install Microsoft Orca:http://msdn.microsoft.com/en-us/library/windows/desktop/aa370557(v=vs.85).aspx
  • unzip the AccessDatabaseEngine.exe or AccessDatabaseEngine_x64.exe file
  • open the AceRedist.msi file in Orca
  • search for two table rows containing the 'CheckOfficeArchitecture' action and drop these rows
  • save the updated AceRedist.msi file

You can now use this file to install the Microsoft Access Database Engine 2010 redistributable on a system where a 'conflicting' version of MS Office is installed (e.g. 64-bit version on system with 32-bit MS Office version)Make sure that you rename the 'mso.dll' registry value as explained above (if needed).

I hate to answer my own questions, but I did finally find a solution that actually works (using socket communication between services may fix the problem, but it creates even more problems). Since our database is legacy, it merely required Microsoft.ACE.OLEDB.12.0 in the connection string. It turns out that this was also included in Office 2007 (and MSDE 2007), where there is only a 32-bit version available. So, instead of installing MSDE 2010 32-bit, we install MSDE 2007, and it works just fine. Other applications can then install 64-bit MSDE 2010 (or 64-bit Office 2010), and it does not conflict with our application.

Thus far, it appears this is an acceptable solution for all Windows OS environments.

Microsoft Access Database Engine 2013 64-bit

drharrisdrharris
9,9085 gold badges37 silver badges53 bronze badges

I had a more specifc error message that stated to remove 'Office 16 Click-to-Run Extensibility Component'

I fixed it by following the steps in https://www.tecklyfe.com/fix-for-microsoft-office-setup-error-please-uninstall-all-32-bit-office-programs-office-15-click-to-run-extensibility-component/

  • Go to Start > Run (or Winkey + R)
  • Type “installer” (that opens the %windir%installer folder), make sure all files are visible in Windows (Folder Settings)
  • Add the column “Subject” (and make it at least 400 pixels wide) – Right click on the column headers, click More, then find Subject
  • Sort on the Subject column and scroll down until you locate the name mentioned in your error screen (“Office 16 Click-to-Run Extensibility Component”)
  • Right click the MSI and choose uninstall

Install the 2007 version, it seems that if you install the version opposite to the version of Office you are using you can make it work.

Matthew DolmanMatthew Dolman
9565 gold badges17 silver badges43 bronze badges

A similar approach to @Peter Coppins answer. This, I think, is a bit easier and doesn't require the use of the Orca utility:

  1. Check the 'HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice14.0CommonFilesPaths' registry key and make sure the value 'mso.dll' is NOT present. If it is present, then Office 64-bit seems to be installed and you should not need this workaround.

  2. Download the Microsoft Access Database Engine 2010 Redistributable.

  3. From the command line, run: AccessDatabaseEngine_x64.exe /passive

(Note: this installer silently crashed or failed for me, so I unzipped the components and ran: AceRedist.msi /passive and that installed fine. Maybe a Windows 10 thing.)

  1. Delete or rename the 'mso.dll' value in the 'HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice14.0CommonFilesPaths' key.

Source: How to install 64-bit Microsoft Database Drivers alongside 32-bit Microsoft Office

JahmicJahmic
7,0788 gold badges47 silver badges60 bronze badges

If both versions of Microsoft Access Database Engine 2010 can't coexists, then your only solution is to complain to Microsoft, regarding loading 64 bits versions of this in your 32 bits app is impossible directly, what you can do is a service that runs in 64 bits that comunicates with another 32 bits service or your application via pipes or networks sockets, but it may require a significant effort.

RafaelRafael
2,6561 gold badge12 silver badges16 bronze badges

Not the answer you're looking for? Browse other questions tagged 32bit-64bitinstallshieldlegacymsde or ask your own question.

Issue:

You are trying to install the 64-bit Access Database Engine on your machine that is running 32-bit Microsoft Office (2007, 2010, or 2013) and you are getting an error message:
'You cannot install the 64-bit version of Microsoft Access Database Engine 2010 because you currently have 32-bit products installed...'

Causes:

Microsoft does not support the side-by-side installation of 32- and 64-bit Microsoft Office or their dependent components.

Solution:

VIDEO DEMONSTRATION
WRITTEN INSTRUCTIONS:
Workaround to install the 64-bit Access Database Engine 2010 on a computer with 32-bit Microsoft Office 2007, 2010, or 2013:

Before you begin, open the Registry Editory (type 'regedit' in the Windows search box under the Start menu and select regedit.exe) and check the following registry key for the value 'mso.dll' is NOT present in: 'HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice14.0CommonFilesPaths'

This registry key value would be present if Microsoft Office 64-bit was installed on the computer, in which case you should be able to install the 64-bit Access Database Engine without using this workaround.
Workaround:

2010

Microsoft Access Database Engine 2007 64 Bit Download

Microsoft access database engine 2010
1. Open the Command Prompt by typing 'cmd' in the Windows search box under the Start menu and selecting cmd.exe

Microsoft Access Database Engine 2010 Redistributable 32 Bit Free Download

Microsoft Database Engine 2010 Download
2. Type the file path and file name of the 64-bit Access Database Engine 2010 install file, followed by a space and '/passive' (this runs the installation without showing any error messages).
For example:

3. Open the Registry Editor by typing 'regedit' in the Windows search box under the Start menu and selecting regedit.exe
4. Delete or rename the 'mso.dll' registry value in the following registry key: 'HKEY_LOCAL_MACHINESOFTWAREMicrosoftOffice14.0CommonFilesPaths'

Access 2010 Redistributable Download

NOTES:

Microsoft Office 2010 Database Engine

Microsoft Access Database Engine 2013 64 Bit

Microsoft Database Engine 2010 Download Free

  • If you do not delete the 'mso.dll' registry value, you will get a 'Reconfiguring' message every time you open up an Office application.
  • You will need to use this same workaround to install Service Pack 1 for Access Database Engine 2010 for 64-bit

Microsoft Database Engine 2010 Download Full

See Also:

64-bit: Configuring ODBC Excel and Access Connections
Downloads:
Access Database Engine 2010 for 64-bit
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=13255
Service Pack 1 for Access Database Engine 2010 for 64-bit
http://www.microsoft.com/en-us/download/details.aspx?id=26605

Microsoft Database Engine 2010 Download

Access Database Engine 2010 64 Bit