Need details on the purpose of having mde file

[Alice]

Can someone let me know what is an mde file, when should
we have one, how to create it and use it?

Thank you,
-Alice

 

[Bob Allen]

-----Original Message-----
Can someone let me know what is an mde file, when should
we have one, how to create it and use it?

Thank you,
-Alice
.

Hi Alice..... Converting and mdb to an mde is quite easy,
and extremely wise.
However, always KEEP the original mdb in a safe secure
place, in the event you have to make changes to forms,
reports, etc., you will need the mdb.
You can not make changes to forms and reports in an mde.

The advantages of an mde are as follows:
1) The database code can not be changed or viewed by any
users.
2) The database tends to load and run alot faster.

Another important thing I like to do is keep ALL tables in
separate "linked" mde databases. (you'll need to have the
backup mdb's of these as well in a safe place in case you
need to make structural changes to the tables.)
The advantage of having the tables linked, is that when
you make changes to the forms or reports in the master
mdb, you dont have to worry about old (not up to date)
data being saved to the revised database once you
reconvert it to mde after making any structural changes to
forms or reports.

As far as how you do the conversion from mdb to
mde....simply go to "Tools"..."Database Utilities"..."Make
MDE".

Hope I was of some help....

Bob

 

[Fritz Range]

An mde is a compliled mdb file. It will be faster than a
mdb and acts just like an mdb except that design is turned
off and some items cannot even be "imported" from an mde.
If you have users that like to play or tinker with your
mdb, this stops them. The file size is also greatly
reduced.

Prior to creating a mde, always complile any modules!

 

[Alice]

Hi Bob,

This information is extremely helpful.
When I try to compile mdb file, I get error
"Microsoft was unable to create an MDE database".

I have very simple database. It has 4 linked tables
linked to SQL SERVER DB. 3 queries and 4 forms.
Forms have little vb code behind them.

I specified one of the forms as startup form.

I don't get any errors for the vb code that I have for
forms. What am I doing wrong or what am I missing here.

Thanks for your help!

-Alice

 

[Albert D. Kallal]

While looking at some code, try compiling the application. If there are any
errors then the mde cannot be created.

 

[Alice]

Hi Dirk,

I am on Access 2000 and not Ac2k2. Any suggestions?

Thank you very much!
-Alice

 

[Joan Wild]

Alice, open any code module, or hit Ctrl-G. Use Debug, Compile all
Modules - you may find some errors. These need to be fixed in order to
compile to a mde.

 

[Tony Toews]

An mde is a compliled mdb file. It will be faster than a
mdb

Not by much if it's even perceptible.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm