Converting Microsoft Access MDE files back to MDB format can be challenging since MDE files are compiled and locked to prevent design changes. However, there are several methods available depending on what components you need to recover and your budget constraints.
Unfortunately, no current method can fully reverse-engineer VBA code from MDE files. The code will need to be recreated by experienced Access developers, though macros can be converted to VBA to provide a starting point.
This method uses free tools to extract forms, reports, macros, and import tables/queries. Perfect for most basic conversion needs.
Tables and queries are natively importable from MDE files into a new database. Create a new MDB file and use the Import function to bring over all tables and queries.
If you only have the front-end database or some table links are invalid, you may get errors with certain tables. In this case, use the paid method below.
Use Serge Gavrilov's free "MDE forms/reports extractor v1.1" to import all forms and reports at once.
📥 Download ToolUse Serge's "SaveAs/Load From Text File v1.0" to export macros from MDE files one at a time to text files, then import them into your new database.
📥 Download ToolIn your new database, select macros and choose "Convert Macros to Visual Basic" from the Tools → Macros menu. This works in Access 2002 and later versions.
You may need to manually edit the generated VBA code to get it to compile properly.
This method handles problematic databases with bad links and large numbers of macros, but requires a commercial tool.
Create an MDB replica of the MDE file using the Tools menu in Microsoft Access.
Make the MDB file the Design Master by choosing "Recover Design Master" from the Tools menu.
Use AccessRecovery software to recover the database file. This tool can handle corrupted files and problematic links.
💳 Purchase AccessRecovery ($399)In the recovered database, highlight each macro and choose "Convert Macros to Visual Basic" from the Tools → Macros menu. The VBA for macros is now importable.
If you need assistance recreating VBA code or handling complex conversions, consider working with experienced Access developers:
Creator of the free extraction tools mentioned above. Offers reasonable rates for custom Access development and code recreation services. His generous contribution of free tools to the community makes him a trusted resource.
Visit Serge's WebsiteExperienced Access developer who reports some success with reverse engineering techniques. His website includes additional resources and connections to other Access professionals.
Visit Peter's ResourcesYou can also find help from Microsoft Access MVPs (Most Valuable Professionals) and experienced developers in Access community forums and professional networks.
• You have a working MDE file with valid table links
• You need basic forms, reports, and macros extracted
• You're comfortable with some manual VBA editing
• Budget is a primary concern
• Your MDE file has broken table links or corruption issues
• You need to process a large number of macros efficiently
• You require maximum recovery success rate
• Time is more important than cost