A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Permenantly Disable Shift Key



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2008, 09:56 PM posted to microsoft.public.access.forms
FA[_2_]
external usenet poster
 
Posts: 12
Default Permenantly Disable Shift Key

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
  #2  
Old May 5th, 2008, 11:16 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Permenantly Disable Shift Key

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.
--
Dave Hargis, Microsoft Access MVP


"FA" wrote:

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

  #3  
Old May 5th, 2008, 11:42 PM posted to microsoft.public.access.forms
Rick Brandt
external usenet poster
 
Posts: 4,354
Default Permenantly Disable Shift Key

Klatuu wrote:
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.

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


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.

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



  #4  
Old May 6th, 2008, 02:20 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Permenantly Disable Shift Key

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


"Rick Brandt" wrote:

Klatuu wrote:
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.

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


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.

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




  #5  
Old May 8th, 2008, 04:35 PM posted to microsoft.public.access.forms
FA[_2_]
external usenet poster
 
Posts: 12
Default Permenantly Disable Shift Key

On May 6, 9:20*am, Klatuu wrote:
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



"Rick Brandt" wrote:
Klatuu wrote:
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.


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


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.


--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt * at * Hunter * dot * com- Hide quoted text -


- 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 ?
  #6  
Old May 8th, 2008, 04:58 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Permenantly Disable Shift Key

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


"FA" wrote:

On May 6, 9:20 am, Klatuu wrote:
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



"Rick Brandt" wrote:
Klatuu wrote:
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.


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


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.


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


- 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 ?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.