password on opening with [SHIFT]

[TjS]

Question.
Our db is protected, in other words, when an user opens the db, no possibility to open any menu is availiable. However, if the user is smart (some are ) then opening the db with the [SHIFT]-key held down the db opens and those users can edit the tables etc.

It would be just enough for our situation to have the possibility to set a password to the [SHIFT]-key when opening the db.

Is it possible? and if it is, please explain to me how

Thanks in advance.

 

[MStef]

Hello TjS!

Look at "Demo1A2002.mdb".
Try open it by "BYPASSKEY", (you can't).
1) Prepare your form that you can enter in MDB (vai password).
2) Shut BYPASSKEY, (look at module).
It is for users only, not for expert.

 

[Oldsoftboss]

Search for Disable shift bypass. Once implemented, it's quite easy. I make it obvious on my Db's, I include a menu item that opens a little password form. If the password is correct, the Db will unlock and the Db window will be displayed. If incorrect, the shift bypass will be disabled.

Dave