Permenantly Disable Shift Key

[FA]

Hi Gurus I have a MS Access database that is very sensitive and
therefore i have disabled the Shift Key but still if someone knows how
to enable it back they can enable the shift key back.
My requirement is to permenantly disable the shift key so nobody even
from other MS access file like (http://www.members.shaw.ca/
AlbertKallal/msaccess/msaccess.html) would be able to re-enable it.

Your expert opinions and guidence are always appreciated.

Thanks

FA

 

[Klatuu]

You can't really permanently disable it. Nothing in Access is every 100 %
secure. The only defense you have is ignorance. If a knowledgable person
knows how to enable or disable the AllowBypassKey property, there is nothing
you can do to prevent it.

 

[Rick Brandt]

You can't really permanently disable it. Nothing in Access is every
100 % secure. The only defense you have is ignorance. If a
knowledgable person knows how to enable or disable the AllowBypassKey
property, there is nothing you can do to prevent it.

If you apply user level security you can make it so that only an admin user
would be able to re-enable the shift key. ULS is also hackable, but it
would add an additional barrier layer.

 

[Klatuu]

Rick,
That would be true through 2003, but would not apply to 2007. The OP did
not state his version. I agree it would be an extra barrier, but, as you
state still hackable.

 

[FA]

Rick,
That would be true through 2003, but would not apply to 2007.  The OP did
not state his version.  I agree it would be an extra barrier, but, as you
state still hackable.
--
Dave Hargis, Microsoft Access MVP





- Show quoted text -

Thanks all for your opinions but i was thinking if we set the file
owner in the code module of disable/enable shift key and if someone
that is not a file owner try to re-enable the shift key then it does
not work unless the file owner tries to do it. The file owner can be
recognized by his/her windows login id. Let me know if this is doable ?

 

[Klatuu]

That wouldn't really help. The AllowBypasskey property can be altered
externally, so the code in the file would not stop that.