Convert an Mde to an Mdb

This article will show you how to convert an MDE to an MDB.

Steps

Free Method

  1. Determine your need. The tables and queries are natively importable from MDE's into a new database. Unfortunately if you only have the front end of a database or some of the table links are no longer valid, you will get an error with those tables and not be able to import them. If this is the case there is an alternative non-free method outlined below.
  2. You can import all the forms and reports at one time using Serge Gavrilov's free tool "MDE forms/reports extractor v1.1"..
  3. To import macros use Serge's "SaveAs/LoadFrom Text File v1.0" also free from the Website above. This allows you to export macros from mde files one at a time to text files. You can then use the same add-in in your new database and import the macros. If you have a large number of macros see the alternative non-free method below.
  4. To regenerate some VBA code from the macros choose "Convert Macros to Visual Basic" from the Macros Menu on the Tools Menu in Access. This works in at least Access 2002. You may have to edit the VBA to get it to compile.

Pay Method

This is the non-free method which will allow you import tables with bad links, and a large amount of macros. Create an MDB replica of the MDE by using the Tools menu.

  1. Make the MDB the Design Master, by choosing Recover Design Master.
  2. Run Access Recovery against the file (the program costs $399 and is available here: .
  3. Everything is importable now from the recovered MDB file but the modules are gone.
  4. Highlight each macro in the recovered database and choose “Convert Macros to Visual Basic? from the Macros menu on the Tools menu. The VBA for the macros is now importable.

Related Articles

Retrieved from "https://kipkis.com/index.php?title=Convert_an_Mde_to_an_Mdb&oldid=279988"