Office Compatibility Issues

Fix 64-Bit MATLAB ADO Provider Errors When Opening an MDB Database

Chanuka GeekiyanageChanuka Geekiyanage Nov 14, 2026 868 views

Question details

Open an MDB database from 64-bit MATLAB when the installed Jet OLE DB provider is 32-bit.

Fix 64-Bit MATLAB ADO Provider Errors for MDB Databases
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.
Before you start

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.

Solution 1Recommended

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.

1
Check driver compatibility

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.

2
Install the 64-bit engine

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.

3
Change the provider

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.

4
Test the connection

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.

Office reinstallation is not always required: A compatible Access Database Engine may be installed separately from Office. If the installer reports a bitness conflict, follow Microsoft's guidance or ask your administrator about changing the existing Office installation.
Free Microsoft Office alternative

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.

Work with documents in a familiar, easy-to-use interfaceOpen and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXReview spreadsheet data exported from an MDB workflowUse a lightweight office suite with a free version
microsoft office alternative - wps office

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.