MATLAB Answers

0

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

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

3 Answers

Answer by MathWorks Support Team on 7 Mar 2018
Edited by MathWorks Support Team on 7 Mar 2018
 Accepted Answer

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.
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.
 

  4 Comments

Show 1 older comment
Hello Shruti, I suggest you to contact MathWorks Technical Support if you still need help with this.
Hello MathWorks Support Team,
This answer did work for me an seemingly solved my problem of connecting to a 32 bit Access database from a 64 bit version of Matlab, the problem is that some of my coworkers who have done this have experienced corruption in their Office programs, causing them to have to reinstall the programs. My question is, do you guys know if there is any other solution to this when working with an Access database with Matlab? Is anyone else aware of this problem (like Microsoft) and is this little issue being addressed?
Thanks!

Sign in to comment.


Answer by francisco lopez on 31 Jul 2016
Edited by Walter Roberson
on 31 Jul 2016

I did not work
no me funciono este metodo

  1 Comment

Sign in to comment.


Answer by Ulrich Wrede on 12 Oct 2019

It worked!

  0 Comments

Sign in to comment.