Fix 64-Bit MATLAB ADO Provider Errors When Opening an MDB Database
Question details
Open an MDB database from 64-bit MATLAB when the installed Jet OLE DB provider is 32-bit.

- Product
- MATLAB and Microsoft Access Database Engine
- Device & OS
- not provided
- Scenario
- A user wants to connect to an MDB database through ADO from a 64-bit MATLAB process.
- Observed behavior
- The connection reports that Microsoft.Jet.OLEDB.4.0 cannot be found because the available provider is 32-bit.
In MATLAB, run computer('arch') to confirm the process architecture; win64 indicates 64-bit MATLAB on Windows. Check your installed Office and Access Database Engine versions before choosing a driver, because existing 32-bit components can block a 64-bit installation.
Install a 64-bit ACE provider and update the ADO connection
Use this approach to connect directly from 64-bit MATLAB to an MDB file.
A 64-bit process cannot load the 32-bit Jet OLE DB provider. A compatible 64-bit Microsoft Access Database Engine provides an ACE OLE DB provider instead.
Review installed Microsoft Office and Access Database Engine components in Windows Settings > Apps. Check Microsoft's current documentation for a supported 64-bit Access Database Engine redistributable and its installation requirements.
Download the supported 64-bit Access Database Engine installer from Microsoft and run it. If existing 32-bit Office components prevent installation, consult your IT administrator before removing or replacing them.
In your MATLAB ADO connection string, replace Microsoft.Jet.OLEDB.4.0 with the ACE provider registered by the installed engine, such as Microsoft.ACE.OLEDB.12.0.
In MATLAB, create an ADO connection with conn = actxserver('ADODB.Connection'); then open it with conn.Open('Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\data\database.mdb;'); Replace the provider name and file path with your installed provider and MDB location.
Use a compatible 32-bit process for the existing Jet provider
Use this alternative if a 64-bit ACE installation is not possible and a suitable 32-bit environment is available.
Work with Office documents in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move your document workflow. It does not install the Microsoft ACE provider or fix MATLAB ADO connections.

Frequently Asked Questions
Why can't 64-bit MATLAB find Microsoft.Jet.OLEDB.4.0?
The Jet OLE DB 4.0 provider is 32-bit, so a 64-bit MATLAB process cannot load it. Install a compatible 64-bit ACE provider and update the provider name in the connection string.
Do I need Office 2007 to use the ACE provider?
No. A compatible Microsoft Access Database Engine redistributable can provide ACE without requiring Office 2007. Check Microsoft's installation requirements and compatibility with your existing Office components.
What if the 64-bit Access Database Engine installer is blocked?
Check Windows Settings > Apps for existing 32-bit Office or Access Database Engine components. Follow Microsoft's compatibility guidance and consult your administrator before removing or changing an Office installation.
Can I keep using an MDB file with ACE?
Yes. A compatible ACE OLE DB provider can connect to MDB files. Set the provider in your ADO connection string and set Data Source to the path of the MDB file.




