How to Bulk Create MDB or ACCDB Files from Access MDE Files
Question details
The user needs a local solution to bulk-extract data tables from legacy 32-bit MDE files and import them into new MDB or ACCDB databases without sending sensitive customer data externally.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Batch extracting tables from multiple older MDE project files locally to protect sensitive customer data.
- Observed behavior
- MDE files cannot be directly converted into MDB or ACCDB formats; a programmed extraction approach is required to systematically copy the tables.
Verify that your local machine has the necessary folder permissions to read the source MDE files and write the new MDB or ACCDB files.
Use a VBA Script to Loop and Extract MDE Tables
Automate the table extraction process using a custom VBA macro that loops through a designated folder, reads each MDE file, and imports its tables into newly generated databases.
Because an MDE file is a compiled database, you cannot directly reverse-engineer or convert it back into an MDB file. However, the data tables within an MDE file remain fully accessible and can be successfully imported into a new MDB or ACCDB database.
By combining a table extraction utility with a folder-looping macro, you can automate this process across dozens of files locally, entirely bypassing the need to send sensitive project files to an external conversion tool.
Open Microsoft Access and create a new blank database. This database will serve exclusively to house and run your VBA extraction macro.
Press the ALT + F11 keys on your keyboard simultaneously to open the Visual Basic for Applications (VBA) editor.
In the top menu, click 'Insert' and select 'Module' to open a blank script window.
Paste your custom VBA script designed to loop through Windows folders. Use the DoCmd.TransferDatabase method or DAO/ADO object models within your loop to connect to each MDE file and pull the tables into a dynamically created MDB or ACCDB destination file.
Press F5 or click the 'Run' icon on the toolbar to execute your code. Monitor the output folder to ensure the new databases are created successfully with the extracted tables.

Need a Lightweight Suite for Everyday Document Tasks? Try WPS Office
While specialized database management like MDE extraction requires Microsoft Access, WPS Office provides an incredibly lightweight, free alternative for your daily word processing, spreadsheet, and presentation needs. It ensures high compatibility with standard Office formats and offers a familiar interface.
- 1. Download the installer: Visit the official WPS Office website and download the free installation package.
- 2. Install the software: Run the installer file and follow the quick on-screen instructions to set up the software.
- 3. Open existing files: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint documents without losing any formatting.

Frequently Asked Questions
Can I fully convert an MDE file back into an MDB file?
No, you cannot fully decompile an MDE file back into its original MDB format because the original VBA source code is compiled and stripped away during creation. You can only extract the remaining data tables.
Why should I extract tables to ACCDB instead of MDB?
ACCDB is the modern default database format for Microsoft Access. It supports newer features such as multi-valued fields, improved encryption, and better integration with other Microsoft products compared to the legacy MDB format.
Can I run the extraction VBA script using Access Runtime?
Access Runtime does not include the VBA design environment, meaning you cannot write or edit code in it. However, if you develop the extraction tool in a full version of Access, Runtime users can execute the pre-packaged macro to perform the extraction.




