How do I find the Microsoft Access Driver (*.mdb, *.accdb) if it is not listed in the ODBC Data Source Administrator?

156 views (last 30 days)
I am not able to add data sources when following the steps to Configure ODBC Data Sources in the documentation on Using Database Explorer. The Microsoft Access Driver (*.mdb, *.accdb) option is missing in the 'Create New Data Source' window.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 25 Aug 2022
Edited: MathWorks Support Team on 25 Aug 2022
The Microsoft Access Driver (*.mdb,*.accdb) does not appear in the ODBC Data Source Administrator dialog box when the bitness of the operating system and Microsoft Access is different. This mismatch occurs when you setup a data source for a 32-bit Microsoft Access database using a 64-bit MATLAB.
To solve this, follow one of these methods:
- Use a 64-bit version of Microsoft Access.
- Refer to the workaround in https://www.mathworks.com/matlabcentral/answers/235949-how-to-connect-to-32-bit-microsoft-access-database-from-64-bit-matlab to connect to a 32-bit version of Microsoft Access. Then, create an ODBC data source using MATLAB. For details about creating ODBC data sources, see
If the above methods do not work and you are using a MATLAB version prior to R2016a, use a 32-bit MATLAB and run 32-bit ODBC Data Source Administrator by following these steps:
1. Navigate to the "C:\Windows\SysWOW64" folder.
2. Find and right-click the executable "odbcad32.exe", and click "Run as administrator". (Running this executable as administrator grants you administrator privileges to create data sources on the computer.)
3. Create an ODBC data source. For details about creating ODBC data sources, see

More Answers (0)

Products

Community Treasure Hunt

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

Start Hunting!