Database Security

[Nick]

Can anyone tell me how to secure my database without using
passwords?
I would like to lock away all design access and the
database window. I only want access to the Main
Switchboard. I have tried *.mde but I can still access the
database window.

Is this possible?

Nick

 

[Nikos Yannacopoulos]

Nick,

You're on the right track with the .mde. To hide the db window as well as
toolbars etc. use the options under Tools > Startup (while working on your
..mdb, then produce a new .mde). Users will still be able to display the db
window and full menu / toolbars, if they know they have to keep the Shift
key pressed while opening the database (this also prevents any autoexec
macro or code from running, forms from opening etc.), but only if they know
it, and they mostly don't! If you still need to disable the Shift key
bypass, you can do it through some (but hardly necessary in my opinion).

HTH,
Nikos