convert mde file

[shachar]

hi all.
how can i see the code in a mde file?
is there any software for doing that?
please help ! !
shachar.

[Jeff Boyce]

You might trying doing a search at Google.com. I don't recall seeing
something like this mentioned -- in fact, as I understand it, the only way
to see what's in an .MDE is to look in the .MDB from which it was created.

Good luck

Jeff Boyce
<Access MVP>

[Douglas J. Steele]

The code is actually stripped out of the MDE, so no, you can't see it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele

"shachar" <sshi...@hotmail.com> wrote in message
news:fa0201c27dac$af67af50$2ae2...@phx.gbl...

[socrtwo]

Apparently no one yet has been able to reverse engineer actual VBA code
but it can be recreated by experienced Access Developers. Although
commercial posting is prohibited here let me put in a plug for Serge
Gavrilov. He has been most generous in providing the free tools below,
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.

Here's how to import everything from MDE's except the modules for free:

1. 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 nonfree 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". It's
available here: http://accesstools.narod.ru/.

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
addin in your new database and import the macros. If you have a large
number of macros see the alternative nonfree 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.

Apparently no one yet has been able to reverse engineer actual VBA code
but it can be recreated by experienced Access Developers. Although
commercial posting is prohibited here 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.

Finally here is the nonfree method which will allow you import tables
with bad links, and a large amount of macros.

1. Create an MDB replica of the MDE by using the Tools menu.

2. Make the MDB the Design Master, by choosing Recover Design Master.

3. Run AccessRecovery against the file (the program costs $399 and is
available here: http://www.officerecovery.com/access/).

4. Everything is importable now from the recovered MDB file but the
modules are gone.

5. 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.

--
Paul Pruitt

Posted via http://dbforums.com