Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Permenantly Disable Shift Key

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FA - 05 May 2008 21:56 GMT
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 - 05 May 2008 23:16 GMT
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.
Signature

Dave Hargis, Microsoft Access MVP

> 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
[quoted text clipped - 8 lines]
>
> FA
Rick Brandt - 05 May 2008 23:42 GMT
> You can't really permanently disable it.  Nothing in Access is every
> 100 % secure.  The only defense you have is ignorance.  If a
[quoted text clipped - 13 lines]
>>
>> FA

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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Klatuu - 06 May 2008 14:20 GMT
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.
Signature

Dave Hargis, Microsoft Access MVP

> > You can't really permanently disable it.  Nothing in Access is every
> > 100 % secure.  The only defense you have is ignorance.  If a
[quoted text clipped - 17 lines]
> would be able to re-enable the shift key.  ULS is also hackable, but it
> would add an additional barrier layer.
FA - 08 May 2008 16:35 GMT
> Rick,
> That would be true through 2003, but would not apply to 2007.  The OP did
[quoted text clipped - 31 lines]
>
> - 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 - 08 May 2008 16:58 GMT
That wouldn't really help.  The AllowBypasskey property can be altered
externally, so the code in the file would not stop that.
Signature

Dave Hargis, Microsoft Access MVP

> > Rick,
> > That would be true through 2003, but would not apply to 2007.  The OP did
[quoted text clipped - 37 lines]
> 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 ?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.