Re: Disable shift key

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 05:43:56 -0800

Hi.

> I have a
> security password set for the DB and now I am attempting to prevent
bypass
> from the shift key.

I hope you are referring to user-level security, not shared-level security,
because the shared-level security (database password) will not prevent
others from bypassing the database application's startup settings by
pressing the <SHIFT> key while opening the database. One must have already
applied user-level security (User ID with user password) in order for the
shift key bypass prevention method to work properly.

> I tried Doug Steele's method without luck.
> I tried Joan Wild's method without any luck.

Does "without luck" mean that you are attempting to open the database while
joined to a workgroup other than the workgroup used to secure the database,
and pressing the <SHIFT> key, but you are still able to open the database?
I'll assume so for the rest of this post, but please tell me if I've guessed
incorrectly.

You didn't post links to either of the methods you are referring to, so I'll
assume that these are the methods I've already seen posted. I know that
Joan's and Doug's methods work for properly secured databases and will work
for yours, too, as long as yours is properly secured by applying user-level
security.

If you haven't been attempting to use these methods with shared-level
security applied (which won't work, as I mentioned earlier), and if the
database can be opened without the workgroup file that was used to secure
it, then it isn't secured properly. You've missed a step. Read and study
the Security FAQ to find which step you missed. You can read the Security
FAQ on this Web page:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

Practice the steps on a copy of your database so that you don't accidently
lock yourself out.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Fysh" <Fysh@discussions.microsoft.com> wrote in message
news:13DFA8FB-6290-49A7-90E9-BCF33B3C12B5@microsoft.com...
> I have researched and read every news group message here, but nothing
seems
> to work. I have an MDB Access 2000 that I am trying to lock down. I have
a
> security password set for the DB and now I am attempting to prevent bypass
> from the shift key. The db has an autoexec macro when opening and the DAO
> reference is set.
>
> I have tried all the examples following without any luck.
>
> http://www.mvps.org/access/general/gen0040.htm
>
> I tried Doug Steele's method without luck. I can still get in by holding
the
> shift key.
> ChangePropertyDdl "AllowBypassKey", dbBoolean, False
>
> I tried Joan Wild's method without any luck. DisableShiftKeyBypass()
Matter
> of fact I keep getting a compile error message, expected:= then the code
in
> the immediate window disappears when I close it and reopen it.
>
> I looked at Albert Kallal site, but I need something within this DB.
>
> The help menu is rather worthless. Can someone assist me on this, I would
> really apprecaiate it? Thanks
>
>
>
>

Relevant Pages

  • Re: Help! Stop the shift from unlocking database
    ... As Rick has already pointed out, any member of the Admins group can "unlock" the Shift key bypass. ... To really lock an Access application down tight you need to implement full blown User Level Security ... Is this necessary in all cases of database development? ... >> There is no menu option for disabling the shift key. ...
    (microsoft.public.access.forms)
  • Re: Security
    ... My only two questions are how come security is such a low ... someone is smart enough to just link up his database to ... >If you need to bypass these startup features, ... you can disable the shift key ...
    (microsoft.public.access.security)
  • Re: Double Passwords
    ... Security FAQ ... and supplying a MDE of your database is sufficient for your purposes... ... Create a startup form that is opened on ... If you need to bypass these startup features, you can hold the shift key ...
    (microsoft.public.access.security)
  • Re: Security
    ... > My only two questions are how come security is such a low ... > someone is smart enough to just link up his database to ... >>If you need to bypass these startup features, ... you can disable the shift key ...
    (microsoft.public.access.security)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)