Disallow Enable Shiftkey from Outside Command

  • Thread starter Thread starter Casey
  • Start date Start date
C

Casey

I have a database that I want to protect by not
allowing the enabling of the allowbypasskey from any
outside database command. I mean as in someone using
another database, calling mine, and then using a command
from the other database to enable the shiftkey-startup (to
view database windows on startup) feature.

I have my main menu form which opens on start up
performing a procedure everytime it is loaded to set the
allowbypasskey to false. Now I want to make sure that the
allowbypasskey is not enabled from outside the database
itself by a command.

I would appreciate any advice on this subject.

Casey
 
You would place the code in a Standard Module. Call it from the Immediate
window (Ctrl + G) ... Assuming your database is properly secured, only
members of your Admin group would be able to change this value.
 
Hi Casey,

You would put it in a module, ensuring you don't name the module the same as
the function.

You just need to call it once (just use Ctrl-G and run it in the immediate
window), and then the next time the database is opened the shift key will be
disabled. You need to be logged in as a member of Admins. Only a member of
Admins will be able to set it back from a different database.
 
Back
Top