mbd and mde files

[elli]

What are these mbd and mde files concerning access...
Ashamed to tell that I have no idea. Anyone to fill me up?

Thanks-elli-

 

[Duane Hookom]

I'm not aware of mbd files but "mdb" are standard Access database files. An
"mde" file is similar to an "mdb" except its forms, reports, and code are
stored in a semi-compiled state. You can't edit the form, report, and code
designs in an "mde" file.

 

[elli]

Thank You Duane,
I meant mdb...
Well, didn't become any wiser though,,,

What do You accomplish in using those or not using those?

-e-

 

[Guest]

mdb files allow you create, modify, and delete Access Objects (Reports,
Forms, Tables, etc). They are useful for building an application. mde files
have that ability removed from them. It is best to deploy mde files to users
so they can only run the application but cannot modify any Access Objects
and, therefore, not muck up (or steal code from) your application.

 

[elli]

Thank U Klatuu)
Will go bed tonight a bit wiser, so it was worthh waking up today)
And you do those mde's just from Tools? Anything else worth knowing before I
destroy my db?))

-elli-

 

[Guest]

Nothing magic. Just make a backup of your mdb and follow the Make MDE wizard.

 

[Douglas J Steele]

And don't lose the MDB: you can't make design changes to MDEs, and you can't
convert them back into MDBs.

 

[Guest]

Hi Klatuu,

Does end-users have to have full MS Access version and licenses to view and
use mde files (forms or reports)?

Thanks!

 

[Douglas J. Steele]

No. They can have the royalty-free run-time version of Access that's
available through VSTO (for Access 2003) or the Office Developer Edition
(previous versions).

See what Tony Toews has at
http://www.granite.ab.ca/access/developereditionfaq.htm for details.