Re: Shift Key function

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I usually put in a "back door" of some type to reset the AllowByPass key property to True.

I also have code that runs to set the AllowByPassKey property to false that runs in a start up routine.

One method is to use an event on an unattached label's click event in an obscure location (such as an about this database form) that when double-clicked runs the code to set the AllowByPassKey to true.

Then the user closes the database and reopens with the shift-key depressed.

You can make the reset harder by using a variety of techniques
-- Require a password to be entered
-- Check to see if the shift key or the control key is depressed when the label is clicked
-- Check to see who the user is
-- or a combination of the above.

Another option is to check out ALbert Kallal's site. I think he has code there that can be run externally to the database to reset AllowShiftBypassKey
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Karren Lorr wrote:
THank you

But how do I change the False to True if I can't get into the database design ?.

Sorry to ask such simple (I hope) questions

At the moment I have a master copy without the shift key disabled and another copy with it set to false (disabled). I was thinking there should be a better way of doing this

?

"Douglas J. Steele" wrote:

I don't understand what you mean that "most of the methods I have seen rely on the application being held on a server". All you need to do is change the value of the AllowBypassKey property from False to True.


Sorry, but it's an all-or-nothing proposition.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Karren Lorr" <KarrenLorr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:40006AC7-4F88-4581-B100-95A87D7EC132@xxxxxxxxxxxxxxxx
I have disabled the shift key (using the AllowBypassKey = False) so that
users can't get into a database sections they are not meant to. I would like
to enable this function on a stand alone application - most of the methods I
have seen rely on the application being held on a server and they all seem to
fail when a database is zipped and e mailed ?

But

I would like to allow "some" staff members but not other to use the shift
key so they can look at the application in design view.

Thank you


Karen Lorr


.

Relevant Pages

  • RE: Shift Key function
    ... Shift Key Startup option (2 weeks ago I got into my sister's database as she ... users you want to see the design the password. ... SetProperties "AllowBypassKey", dbBoolean, True ...
    (microsoft.public.access.gettingstarted)
  • Re: Password for accessing tables and queries
    ... You might want to try MVP Albert Kallal's nifty Shift Key Bypass ... > "AllowByPassKey" is that because I thought other than "AllowByPassKey" ... ' the current database to either True or False. ... On Error GoTo SetAllowBypassKeyErr ...
    (microsoft.public.access.security)
  • Shift Key function
    ... I have disabled the shift key (using the AllowBypassKey = False) so that ... users can't get into a database sections they are not meant to. ... key so they can look at the application in design view. ...
    (microsoft.public.access.gettingstarted)
  • RE: Access Database is shift key is locked ?
    ... Search the forums for AllowBypassKey. ... > how can a person access a database if the shift key has been coded out, ...
    (microsoft.public.access.forms)
  • RE: Disable By Pass Shift Key - Joan Wild
    ... Joan, ... You mentioned in a previous thread title as above that once you have disabled the Shift Key, you could use another database to reset the property. ...
    (microsoft.public.access.setupconfig)