File Format & Compatibility

Convert an Access MDB Database to ACCDB in Access 2016

Maira MehtabMaira Mehtab Nov 20, 2026 868 views

Question details

Convert an Access MDB application with Visual Basic code to ACCDB and check its compatibility with Access 2016.

Product
Microsoft Access 2016
Device & OS
not provided
Scenario
The user wants to migrate an existing MDB database application to the ACCDB format while preserving its code and reviewing its settings.
Observed behavior
The desired result is an ACCDB database that opens in Access 2016 and whose application features and VBA code have been tested.
Before you start

Check which Access version created the MDB and whether the application relies on features such as replication or user-level security, which ACCDB does not support. Make a copy of the MDB and identify any linked databases or required object libraries before conversion.

Solution 1Recommended

Save the MDB as ACCDB and test the application

Use Access 2016 to convert a supported MDB, then review references and test the converted application.

Well-designed relational Access applications often migrate successfully, but conversion does not guarantee that every feature, setting, or VBA reference will work unchanged.

ACCDB does not support MDB replication or user-level security. If the original application depends on either feature, review alternatives before migrating.

1
Open the MDB

In Access 2016, select File > Open and browse to the MDB file. If Access cannot open an older format, use a compatible earlier Access version to convert it to a format that Access 2016 can open.

2
Save as ACCDB

Select File > Save As > Save Database As, choose Access Database (*.accdb), and click Save As. Choose a name and location for the new file.

3
Check VBA references

Open the converted database and press Alt+F11 to open the VBA editor. Select Tools > References and review any entries marked MISSING; resolve them using the libraries required by the application.

4
Qualify and compile code

In the VBA editor, qualify ambiguous declarations, such as changing Recordset to DAO.Recordset or ADODB.Recordset as appropriate. Explicitly qualify object, control, and method references where needed, then select Debug > Compile to check the code.

5
Test database functions

Return to Access and open the application's forms, reports, queries, and linked tables. Run its usual workflows and review database settings to confirm they behave as expected.

Keep the original MDB: Keep the original file until you have verified the converted application, including its VBA code and external connections.
Free Microsoft Office alternative

Work with exported Access data in WPS Spreadsheets

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Microsoft Office formats. Export Access data to an Excel workbook to continue working with it in WPS Spreadsheets; WPS does not convert MDB databases to ACCDB or run Access applications.

Review and analyze data exported from Access in spreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where is the ACCDB conversion option in Access 2016?

Open the MDB, then select File > Save As > Save Database As. Choose Access Database (*.accdb) and click Save As.

Will my VBA code work after converting an MDB to ACCDB?

It may work, but you should compile and test it. In the VBA editor, check Tools > References for missing libraries and qualify ambiguous declarations, such as DAO.Recordset or ADODB.Recordset.

What if Access 2016 cannot open my MDB file?

The file may use an older Access format that Access 2016 cannot open directly. Use a compatible earlier Access version to convert it to a format Access 2016 can open, then save it as ACCDB.

Does ACCDB retain MDB replication and user-level security?

No. ACCDB does not support those MDB features. Review how the application uses them and plan alternatives before converting.

Can WPS Office convert an Access database to ACCDB?

No. Use Microsoft Access for the database conversion. For spreadsheet analysis, you can export data from Access to an Excel workbook and open it in WPS Spreadsheets.