How to connect to 32-bit Microsoft Access Database from 64-bit MATLAB?
76 views (last 30 days)
Show older comments
MathWorks Support Team
on 24 Aug 2015
Edited: MathWorks Support Team
on 17 Apr 2024 at 15:44
How to connect to 32-bit Microsoft Access Database from 64-bit MATLAB?
Accepted Answer
MathWorks Support Team
on 17 Apr 2024 at 0:00
Edited: MathWorks Support Team
on 17 Apr 2024 at 15:44
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.
0 Comments
More Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!