How to connect to 32-bit Microsoft Access Database from 64-bit MATLAB?
116 views (last 30 days)
MathWorks Support Team on 7 Mar 2018
Edited: MathWorks Support Team on 7 Mar 2018
NOTE: These instructions work only if the version of Office is different from the version of the Microsoft Access database engine.
The following workaround requires Administrative privileges on the machine. Please contact your organization's IT department if required.
First install 64-bit Microsoft Access Engine 2010 from the Microsoft website:
Download the file named “AccessDatabaseEngine_x64.exe” on to your local machine.
Do not run the exe file. Before you begin, open the Registry Editor (type "regedit" in the Windows search box under the Start menu and select regedit.exe) and check the following registry key for the name "mso.dll" is NOT present in: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths"
This registry key name 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.0\Common\FilesPaths"
5) Restart MATLAB and create a data source for 32-bit MS Access Database from 64-bit MATLAB.
*DISCLAIMER: *This workaround may have adverse side-effects on the system, results of which are unknown as of now. Please keep a backup of the Windows Registry and other important files before executing it.
More Answers (3)
Bereketab Gulai on 20 May 2020