RE: Disable access to the database window

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Klatuu,

Actually I have used the AllowBypassKey Property in another db project.
However, in doing so you do open up a "window of opportunity". If the user
enters with shift, after you have exited, then they get in as well. I've
mimized this chance, in my other application, by adding a keypress event to a
particular control that set the AllowBypassKey. This way I only open the
window when I need to.

However, to close even this window, as I've recently learned, set
AllowBypasskey to FALSE, then use either permissions (checked in an Autoexec)
or a backdoor (like a special key sequence) to bring up the database window
programmatically.

Regards,
Leif

"Klatuu" wrote:

> The Special Access keys is global in a sense. It is specific to that mdb.
> You could distribute a different mdb to the users that you do for an admin
> user. That is kind of klugy. There is, however, another solution. It is
> the AllowBypassKey Property. There is a pretty good example in VBA Help.
> The way I have implemented it requires some sort of security implementation.
> What I do during my startup routine is check to see if the user has admin
> authority. If he does, then I set AllowBypassKey to True, otherwise, I set
> it to False. Notice in the Help file that this does not take effect until
> you close and reopen the mdb. So, for an admin person to get into the
> database, they have to go in two time. Once that recognizes them as an admin
> user, and set the property to True. Then close the mdb, and open it with the
> Shift key down and they are in. This also means your app has to be
> constructed so that a user cannot get direct access to anything other than
> the object you allow them.
>
>
>
> "Leif" wrote:
>
> > I would like to disable access to the database window for a general user, but
> > allow an admin user access.
> >
> > I know about the Special Access keys under start up, but my understanding is
> > that this is a global, rather then a user specific, setting.
> >
> > I was looking for a keypress event that would trap all Access keys, but that
> > seems to be form specific.
> >
> > Another idea, perhaps I could disable F11, but bring up the database window
> > using code? If this was possible I could place it on a menu, since the admin
> > user has a different menu.
> >
> > Any suggestions? Thanks.
> >
.

Relevant Pages

  • RE: Disable access to the database window
    ... >> Actually I have used the AllowBypassKey Property in another db project. ... >> window when I need to. ... It is specific to that mdb. ... >>> You could distribute a different mdb to the users that you do for an admin ...
    (microsoft.public.access.modulesdaovba)
  • RE: Disable access to the database window
    ... It sound like you have multiple users using the same copy of the mdb. ... in doing so you do open up a "window of opportunity". ... >> The Special Access keys is global in a sense. ... >> You could distribute a different mdb to the users that you do for an admin ...
    (microsoft.public.access.modulesdaovba)
  • Re: root has less menus
    ... Figuring nautilus was too much a part of my ... It works if you don't drag and drop files from one window to another ... Ubuntu doesn't show admin applications when the user is not an admin ... Your first solution is a good solution, ...
    (Ubuntu)
  • HTA - Mutliple questions about using WScript.Shells Run Method and control.exe
    ... LUA environment (one normal account, one admin account used for admin ... the interface and they will execute with admin rights because the HTA ... Is there a command line to kick off the entire Control Panel window ...
    (microsoft.public.scripting.vbscript)
  • Re: Accidetally changed me Admin password
    ... If you are currently logged on to the administrative account, ... type CTRL-ALT-DEL and a window should pop up. ... > Admin password and now I cant restart my computer as I ...
    (microsoft.public.windowsxp.security_admin)