Others

How to Bulk Create MDB or ACCDB Files from Access MDE Files

Tauseeq MagsiTauseeq Magsi Oct 29, 2026 870 views

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.

How to Bulk Extract Tables from MDE Files to MDB or ACCDB
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.
Before you start

Verify that your local machine has the necessary folder permissions to read the source MDE files and write the new MDB or ACCDB files.

Solution 1Recommended

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.

1
Set up a new database utility

Open Microsoft Access and create a new blank database. This database will serve exclusively to house and run your VBA extraction macro.

2
Access the VBA Editor

Press the ALT + F11 keys on your keyboard simultaneously to open the Visual Basic for Applications (VBA) editor.

3
Insert a new module

In the top menu, click 'Insert' and select 'Module' to open a blank script window.

4
Write the looping and extraction code

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.

5
Execute the batch process

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.

Use a VBA Script to Loop and Extract MDE Tables
Data Privacy Preserved: Processing the files locally using a custom VBA script ensures that sensitive customer information never leaves your internal network.
Free Microsoft Office alternative

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. 1. Download the installer: Visit the official WPS Office website and download the free installation package.
  2. 2. Install the software: Run the installer file and follow the quick on-screen instructions to set up the software.
  3. 3. Open existing files: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint documents without losing any formatting.
Fully compatible with Microsoft Excel, Word, and PowerPoint formats (.xlsx, .docx, .pptx).Lightweight design that installs quickly and runs smoothly on older hardware.Familiar user interface with zero learning curve for a seamless migration.Built-in robust PDF editor to manage, merge, and convert documents effortlessly.
microsoft office alternative - wps office

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.