By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

MDE file -- advantages and disadvantages

P: n/a
Hi:

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!

THanks

John Baker
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
John Baker wrote:
Hi:

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!


In an MDE, the objects's design cannot be reached nor changed. You
cannot see the code.

That is both an advantage (in production systems) as a handicap (during
development--nah, then it's impossible)

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #3

P: n/a
John Baker wrote:
Hi:

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!


As Keith & Bas said, protects source code and makes the db file as small
as it will get. Speed wise, you wouldn't notice the difference between
uncompiled and compiled code running since it's not true compiled code
anyway (just tokenised).

The downside is that no form/report may be opened in design view even
through code. Some people create/edit forms on the fly this way or just
change printing preferences of a report. If you do none of these then
this isn't a downside for you :-)

--
This sig left intentionally blank
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.