MDE File Question

[Guest]

I've converted an access 2003 database into an MDE file but when i open the
MDE file using my shift key i can still see all my forms, code, reports etc.
This isnt normal is it. I though MDE files were to hide all the code n stuff??

 

[Guest]

Can you go into design mode for any of the forms, reports, or modules? If so
you really don't have an MDE file. The forms can be seen; however, aren't
they just a little grayed out compared to the tables?

 

[Guest]

You can see the Forms/Reports/modules names only, but you can't open them in
design view. So you are protecting your code from others to use.

 

[Guest]

You can hide the database window by selecting Tools|Startup on the main
database menu bar and unchecking 'Display Database Window'. Users will still
be able to open it with the F11 key, however, so you should also uncheck 'Use
Access Special Keys' in the same dialogue.

Note that if you've used code which selects an object in the database
window, e.g. a report to be printed using the PrintOut method of the DoCmd
object this will display the database window regardless of the above
settings, so you need to avoid that. With a report the way is to open it
transparently in print preview, print it and then close it again.

The above must be done in the original .mdb file of course before creating
the .mde file from it.

If you want to disable the by-pass key so that the startup options can't be
by-passed by holding down the Shift key you can do this in code by setting
the database object's AllowBypassKey property to False in code.

Ken Sheridan
Stafford, England