mdb vs mde

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi,

I dont really know the differance between mdb and mde.
Can anyone can explain that to me?

Thanks,
Tom
 
My take on it is this

mdb is fully editable to the last bit, all your hard work in coding, macros,
etc is available for others to steal. Which if you have hours in which you
probably will, it is nice to have some of the rewards for your hard work.
However, do remember open source files are great for others to learn off of
also.

mde will lock all code and ability to design. I would also recommend
keeping your original mdb because a mde cannot be undone, once a mde always a
mde.
 
Thanks.
default105 said:
My take on it is this

mdb is fully editable to the last bit, all your hard work in coding,
macros,
etc is available for others to steal. Which if you have hours in which
you
probably will, it is nice to have some of the rewards for your hard work.
However, do remember open source files are great for others to learn off
of
also.

mde will lock all code and ability to design. I would also recommend
keeping your original mdb because a mde cannot be undone, once a mde
always a
mde.
Click to expand...
 
Hi Tom,

The .mde format is usually used when distributing an application to
end-users. You cannot edit forms, reports or modules in .mde files. The
canocial text (ie. human readable text) in your VBA code modules is stripped
out of the .mde database. Only the "P" code remains, which is in a compiled
form.

A couple of advantages of .mde file format include:
1.) The project cannot become decompiled
2.) References tend to be more stable (ie. not as many issues with lost or
missing references) and
3.) Your users (and you too) cannot make changes to forms, reports and modules

If you have any VBA code that requires saving changes to an object in design
view, then the .mde format is not a suitable option.


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________
 
Back
Top