John Baker <Ba******@Verizon.net> wrote:
Can someone tell me in simple terms why one should create an MDE file
from an mdb file, and what the adfvantages/disadvantages are? In other
words, why would one wish to create one, and what should inhibit one
from creating one!
Hi John,
An mde file is a fully compiled and compacted version of the mdb, that is
to say there is no textual representation of VBA contained therein. This
gives the advantage of a leaner FE that is less likely to become corrupt
and, should you wish to hide your design from prying eyes, gives an added
level of security (because the VBA cannot be viewed or edited). There is
also a performance benefit.
You should always preserve your original mdb though, because it extremely
difficult, at best, to reverse engineer an mde.
HTH - Keith.
www.keithwilby.com