By Paul Pruitt - MCP, CompTIA A+,
CompTIA Net+, HDI Helpdesk Analyst
Free Method
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.
-
You can import all the forms and reports at one time using Serge
Gavrilov's free tool "MDE forms/reports extractor v1.1". It's available
here: http://accesstools.narod.ru/.
-
To import macros use Serge's "SaveAs/Load From 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.
-
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.
-
Apparently no one yet has been able to reverse engineer actual VBA code
but it can be recreated by experienced Access Developers. Let me put in a
plug for Serge Gavrilov. He has been most generous in providing the free
tools above, and his rates are quite reasonable. If you need help recreating
code Serge may be able to help. His E-mail address is on the Web page above.
I am not affiliated with him.
-
There are other Access Developers another one is Peter Walker, see his
site here: http://www.papwalker.com/links.html.
He reports some success at reverse engineering. There are others that you
can get to through his pages that might help you recreate code as well as
any of the MVP's and developers in the forum here.
Non-Free Method
Finally here 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.
-
Make the MDB the Design Master, by choosing Recover Design Master.
-
Run AccessRecovery against the file (the program costs $399 and is
available here: http://www.officerecovery.com/access/).
-
Everything is importable now from the recovered MDB file but the modules
are gone.
-
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.