How to Install 64-bit MS Database Drivers with 32-bit MS Office
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. «
Microsoft does not support the side-by-side installation of 32- and 64-bit Microsoft Office or their dependent components.
Be aware that changing the Windows Registry could cause problems. It is highly recommended that you back up the registry before making any changes.
Note : EarthSoft Assumes no liabilities for problems introduced when making changes to the registry.
To back up the registry in Windows:
1. Select Start , type regedit.exe in the search box, and then press Enter . If you are prompted for an administrator password or for confirmation, type the password or provide confirmation.
2. In the Registry Editor, locate and click the registry key or subkey that you want to back up.
3. Select File > Export .
4. In the Export Registry File dialog box, select the location to which you want to save the backup copy, and then type a name for the backup file in the File name field.
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_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths»
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.
1. Open the Command Prompt by typing «cmd» in the Windows search box under the Start menu and selecting cmd.exe.
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).
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_MACHINE\SOFTWARE\Microsoft\Office\14.
• 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.
Copyright © 2024 EarthSoft, Inc. • Modified: 04 Aug 2023
How to resolve: «You cannot install the 32/64 bit version of Microsoft Access Database Engine because you currently have 64/32 bit Office»?
Got a bit of chicken and egg here; if I try to install Access Database driver 64-bit version, I see:
You cannot install the 64-bit version of Microsoft Access Database Engine 2016 because you currently have 32-bit Office products installed. If you want to install 64-bit Microsoft Access Database Engine 2016, you will first need to remove the 32-bit installation of Office products. After uninstalling the following product(s), rerun setup in order to install 64-bit version of Microsoft Access Database Engine 2016:
Office 16 Click-to-Run Extensibility Component
No biggie, I thought – I’ll use the 32-bit version:
You cannot install the 32-bit version of Microsoft Access Database Engine 2016 because you currently have 64-bit Office products installed. If you want to install 32-bit Microsoft Access Database Engine 2016, you will first need to remove the 64-bit installation of Office products. After uninstalling the following product(s), rerun setup in order to install 32-bit version of Microsoft Access Database Engine 2016:
Office 16 Click-to-Run Extensibility Component 64-bit Registration
(Both windows had the title “Microsoft Access database engine 2016 (English) Setup”.) Hah.. I don’t really get a choice about uninstalling particular components – the original install was an MSDN/Action Pack «double click this and it will install everything», so I’m not certain how to go about removing just this one thing it complains of. Are there any workarounds I can try to get one of these to install?
- microsoft-office
- 64-bit
- microsoft-access
- 32-bit
- microsoft-office-2016
Help Desk
Error: You cannot install 64-bit Microsoft Access Database engine
Modified on: Wed, Jun 8, 2022 at 8:59 AM
Issue:
You installed a new release of DIAGRAMS, DBWorx (PIDMO), and any other application requiring 64-bit Access and receive the error shown below
Causes:
Microsoft does not support side by side installation of 64-bit and 32 bit Microsoft Office
Solution:
You can install the 64-bit engine passively through a command prompt to have them both installed.
- Ensure the mso.dll is NOT present in the registry under key below:
- Run the Command Prompt by typing CMD in the Windows search bar at the start menu. By right clicking on the cmd.exe that is found and choosing Run as Administrator.
- At the command prompt type:
2010 = «C:\Program Files\ECE Design\DBWorx\Support\AccessDatabaseEngine_x64.exe» /passive
2016 = «C:\Program Files\ECE Design\DBWorx\Support\AccessDatabaseEngine_x64.exe» /quiet
- During the install you will see (note, it may flash on the screen very quickly!)
Notes:
If the mso.dll is found before manually installing the 64-bit Access Database Engine, you should already have 64-bit Microsoft Office installed.
Download Access Database Engine 2016 64 bit
Did you find it helpful? Yes No
Sorry we couldn’t be helpful. Help us improve this article with your feedback.
ECE Design: When People Talk, Great Things Happen!
CADWorx®, CAESAR II™, PV ELITE™, ISOGEN™ are registered trademarks of Hexagon PPM.
ECE Design is not associated Hexagon PPM as of March 2018
Can’t establish a connection to Access Database Engine OLE DB
This article provides a resolution to an issue where you can’t establish a connection to Access Database Engine OLE DB in Microsoft Power Automate for desktop.
Applies to: Power Automate
Original KB number: 5004577
Symptoms
Consider the following scenario in Microsoft Power Automate for desktop:
- Access Database Engine OLE DB provider doesn’t show in the Data Link Properties window list when you establish a connection with database actions.
- When you use a connection string directly, you may receive the following error message:
Can’t connect to data source The ‘Microsoft.ACE.OLEDB.1x.0.’ provider is not registered on the local machine.
Cause
This error message occurs because the appropriate 64-bit driver isn’t installed on your machine. Kindly note that Power Automate for desktop is based on 64-bit architecture and thus is only compatible to 64-bit database drivers.
Resolution
Verify that you have 64-bit Access Database driver installed on your machine by going to ODBC Data Source Administrator (64-bit) application on windows and then the Drivers tab. If you don’t see «Microsoft Access Driver» in the list, you need to download and install the 64-bit version from Microsoft Access Database Engine 2016 Redistributable.
If you have 32-bit Office installed on your windows and can’t upgrade to 64-bit version of Office, continue reading the rest of the article.
Follow the steps below to have both 32-bit and 64-bit Access drivers co-exist on your machine:
- Uninstall all the Access driver versions from your machine.
- Go to the registry editor on your desktop (You can search for it in the search bar) and navigate to both the paths below if they exist: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\FilesPaths
- Check if the «mso.dll» registry key is present in both the above paths. If the key is present, this means that you haven’t uninstalled all the drivers. Verify the drivers on your system and uninstall all the Access drivers and verify the registry editors’ paths mentioned in step 2 again.
- Download a new version of Microsoft Access Database Engine from the Microsoft official website, and then install the 64-bit driver using command prompt (CMD) with the command AccessDatabaseEngine_x64.exe /quiet for 2016 Redistributable.
- Go back to registry editor and delete the «mso.dll» registry key and its value in the following path:
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\FilesPaths
Lastly, install the 32-bit driver using command prompt (CMD) with the command AccessDatabaseEngine.exe /quiet for 2016 Redistributable. This will allow both the 32-bit and 64-bit drivers to co-exist on your machine.