How to connect to 32-bit Microsoft Access Database from 64-bit MATLAB?
76 ビュー (過去 30 日間)
古いコメントを表示
MathWorks Support Team
2015 年 8 月 24 日
編集済み: MathWorks Support Team
2024 年 4 月 17 日 15:44
How to connect to 32-bit Microsoft Access Database from 64-bit MATLAB?
採用された回答
MathWorks Support Team
2024 年 4 月 17 日 0:00
編集済み: MathWorks Support Team
2024 年 4 月 17 日 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 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Database Toolbox についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!