Clear Filters
Clear Filters

How to connect to 32-bit Microsoft Access Database from 64-bit MATLAB?

51 views (last 30 days)

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 28 May 2024 at 0:00
Edited: MathWorks Support Team on 17 Apr 2024
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:
https://www.microsoft.com/download/details.aspx?id=13255
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.
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). 
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_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 (0)

Products


Release

R2015a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!