Disabling Database Window

[Matt]

I currently have a form that starts up automatically on my Access Database

I would like to set a password on the database window so that when the user holds down shift, it will not allow them to view the database window unless they supply the correct password

Is this possible

I saw I can use the bypasskeyproperty to disable the shift command, but how would I be able to change it back to true later if I set that to false

Thanks in advance
Matt

 

[Rick Brandt]

I currently have a form that starts up automatically on my Access Database.

I would like to set a password on the database window so that when the

user holds down shift, it will not allow them to view the database window
unless they supply the correct password.

Is this possible?

No because the Shift bypass would execute before any code from your app
could possibly run.

I saw I can use the bypasskeyproperty to disable the shift command, but

how would I be able to change it back to true later if I set that to false?

You have to have similar code as a "back door" that only you know how to
execute that re-enables the shift key. You can even do this from another
database file altogether. Of course so can anyone else that knows how if
you don't use User Level security at the same time.