473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MDE file -- advantages and disadvantages

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
3 9369
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Sherry Littletree | last post by:
Hi All I am working on a site that has a large amount of common html on all its web pages. I am looking for a way to place this in a single file so, if changes are made, I can change this...
26
by: jj | last post by:
Care to enlight? Thanks!
1
by: Husam | last post by:
Hi EveryBody: I have research about advantages and disadvantages of C++ languages In one of my programming courses. Can Any one help me and told me about advantages and disadvantages of C++...
1
by: vumani | last post by:
what is the advantages and disadvantages of Ms SQL server and java servletts front-end on the clien end. what is the advantages and disadvantages of Ms Access on the server, connected via JDBC and...
1
by: vibee | last post by:
what are the advantages and disadvantages of normalization, and if i alread have a single talbe with a single form, is it too late to normalize thanks
8
hsn
by: hsn | last post by:
i would like to know what are the security advantages and disadvantages in HTML thank you
1
by: bantunks | last post by:
Hello, I am trying to figure out the advantages and disadvantages of exposing interfaces through Opaque data types in C. I have figured/found out the following two advantages 1. Higher level of...
3
by: Damodhar | last post by:
what is the advantages and disadvantages for register_globals = on
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.