How to Open and Upgrade an Access 2010 MDE File in Access 2019
Question details
The user needs to know if an Access 2010 MDE file can be used, upgraded, or reverse-engineered in Access 2016 or 2019 because the original MDB source file is missing.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Attempting to migrate or continue using a legacy database application in a newer Access environment without access to the original source code.
- Observed behavior
- The database is restricted to the compiled MDE format, preventing direct editing of the underlying VBA code, forms, or database structure in newer Access versions.
Ensure you have a backup copy of the original Access 2010 MDE file stored securely before attempting any opening, conversion, or reverse-engineering processes in newer versions of Access.
Open and Run the MDE File Directly in Access 2016 or 2019
Because MDE files are compiled versions of Access databases, you can often run them directly in newer versions of Access without upgrading the underlying structure.
Microsoft Access maintains a high level of backward compatibility for compiled databases. You can generally execute Access 2010 MDE files in Access 2016 or 2019 to interact with the data and use the forms. However, because the file is an MDE, you remain unable to edit forms, reports, or VBA code, just as in the original 2010 environment.
Open Microsoft Access 2016 or Access 2019 on your computer.
Click on the 'Open' tab from the left menu, then select 'Browse' to navigate to the local folder containing your Access 2010 MDE file.
Select the MDE file and click 'Open'. If prompted with a security warning regarding macros or active content below the ribbon, click 'Enable Content' to allow the application to run its background scripts.

Extract Tables to a New Access 2019 Database
If you cannot modify the application but need to salvage the underlying data, you can import the MDE tables into a brand new Access database.
Consult a Reverse Engineering Specialist
If you must fully recover the VBA code, forms, or reports to upgrade the application properly, you will need to rely on specialized MDE conversion services.
Manage Your Exported Data and Reports with WPS Office
While Microsoft Access is strictly required to open and execute proprietary MDE database files, WPS Office provides a free, highly compatible alternative for analyzing your exported data. Once you extract tables from your legacy databases, bring them into WPS Spreadsheet for powerful, lightweight data management.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free office suite and install it on your PC or Mac.
- 2. Import Exported Data: Export your accessible MDE table data as CSV or Excel files from Microsoft Access, then open them instantly in WPS Spreadsheet.
- 3. Analyze and Report: Use WPS Spreadsheet's advanced formulas, pivot tables, and charting tools to manage your database records visually without needing complex Access forms.

Frequently Asked Questions
Can I convert an MDE file back to an MDB file natively in Access?
No, Microsoft Access does not provide a native tool to decompile or convert an MDE file back to its original MDB format. The MDE format intentionally strips out the readable VBA source code to protect intellectual property and prevent modifications.
Will an Access 2010 MDE file run on a 64-bit version of Access 2019?
It depends on how it was originally compiled. If the Access 2010 MDE was compiled in a 32-bit version of Access, it will generally not run on a 64-bit version of Access 2016 or 2019. You must match the bitness (32-bit or 64-bit) of the compiled MDE file with your current Access application.
How can I extract the data from an MDE file without the source code?
Even if the design and code are locked, the data tables within an MDE file are usually accessible. You can create a new blank database in Access 2019, go to 'External Data', select 'New Data Source', and import the tables directly from the locked MDE file.




