Access Security

[NHogan]

What is the best way to disable the Shift bypass and database window shortcut key's on the front end of a database. Currently I have security which works well through a .mdw file but users can hit F11 or use the shift key to to get to the database window and bypass the Autoexec. I want to be able to enter the database window with an Admin account but disable the shortcut keys for all users?

I have code which will disable the Shift bypass and know how to not allow F11 but don't know how I should be applying them. Please help.

 

[SgtJarrow]

My first suggestion is not to use an autoexec macro.....instead, put all the actions you autoexec macro performs into the OnOpen event of your splashscreen and use the startup options to open this form at startup.....

The best way I have found to "disbale" the F11 key is to use an AutoKeys Macro....set the F11 key to display a message to the effect that this option is not available. Then the code window will not be displayed.

As with any database change such as these, ensure you have a good backup and some sort of "back door" into these features...because you will need them at some time in the future. And no security is 100% foolproof.....

And finally, probably one of the best security features you can include is training the user. Simply giving the user training on your app, and what can and cannot be done, will go a long way. If you have included auditing features, you can simply determine who, after having been told not to use these function, is still using the functions and go from there.... Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III, MCP, Network+, A+
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com