Protect MDB

[wiz69]

Hi,
it's possible to protect an MDB with ACCESS 2003?
I've yet protect MDB with protection wizard and MDW, but, if the
user click on the MDB file and press the SHIFT BUTTON, the MDB show
structure, without any protection.

How is the method to protect completely the MDB FILE?

If I use the PASSWORD PROTECTION, also the user that have to read
information must know the password.

Thanks in advance,
Wiz

 

[Joan Wild]

You need to
Create custom menus/toolbars for use throughout your application.
Create a startup form (a main menu form if you have one) that is opened on
startup.
Use the features in Tools, Startup to
set the startup form
set your default menu (the custom one you made)
disable all the checkboxes about allowing built in menus, toolbars,
changes etc.
hide the db window (ensure the custom menu you create does not
include the Windows, Unhide item)
Uncheck the allow special keys (this will disable the F11 key, among
others)

You can disable the shift key bypass - there's an example in help for doing
this(look for AllowBypassKey) or at
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

You can also create a MDE from your database, which will prevent changes to
forms, reports and modules (If you do this, be certain to keep your original
mdb in case you need to make changes).