Disabling Shift Key 1

[tpearo]

Does anyone know how to disable the shift key for a Access 2000 database. I have made the database into mde format but am concerned that certain users can still get to the underlying tables and queries bypassing the menus by using the shift key at opening the database. I know that I've seen some threads about this subject in the past but can't find them or remember what to do.

 

[rhicks]

Check the FAQ section of this forum for information on how to do this, this was based on Access 97, but the version should not effect the outcome.

HTH X-)
RDH

Ricky Hicks
rdhicks@mindspring.com

 

[tpearo]

I've read the solution in the FAQ section however I do not understand where the code needs to be written. Is there a way to invoke this code at start-up so that the code automatically runs and the user is prevented from using the shift key to by pass the menus?

 

[rhicks]

You can place the code in the form module or in a stand alone module. You call the subs any way you wish. The point I think you are missing is that the code needs to be executed only once. Then, from that point, the shift will not be active during the startup again until you execute the sub that re-enables the shift key. It does not need to be executed each time the db is started up. The code turns the shift key "Off" by altering it's property. This property will remain in this state until the the property is altered again by running the re-enable code. This is why it is extremely important for you to have a way to reset the shift key to "On", or you will have also locked yourself out.

Be very careful.....make a backup, just incase you do something wrong.

HTH
RDH

Ricky Hicks
rdhicks@mindspring.com