Re: Workgroup security files.

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

From: miaplacidus (Mia_placidus_at_hotmail.com)
Date: 07/21/04

  • Next message: Taher: "make table query" 
    Date: Wed, 21 Jul 2004 11:01:07 -0700

    >-----Original Message-----
    >"miaplacidus" <mia_placidus@hotmail.com> wrote in message
    >news:12df01c46f20$71655740$a401280a@phx.gbl...
    >> I don't think that was the answer to my question.
    >>
    >> 1). If I have an employees DB and a press release DB on
    my
    >> computer, then I apply security to the employees DB; why
    >> does that affect the press release DB?
    >
    >It doesn't. Whether you are prompted at Access launch is
    controlled by the
    >workgroup file you are using, not the database file you
    are opening.
    >
    >There are two separate things happening that are related,
    but distinct.
    >You open Access using a workgroup file. Which workgroup
    file is either
    >specified as a command line argument or else your default
    workgroup file is
    >used.
    >
    >The workgroup either has a password on the "Admin" user
    or it doesn't. If
    >it does you are required to provide a user name and a
    password. If it
    >doesn't you are automatically logged in as "Admin".
    >
    >Access now has a session started and "knows" who the
    current user is and to
    >what groups he is a member. Nothing about any *file*
    that might be opened
    >has come into play yet.
    >
    >Now then, when a specific file is opened Access takes the
    user and group
    >information that it already knows and checks to see if
    the current user has
    >proper authorities to the file being opened (because that
    information is
    >stored in the file being opened). If the user has proper
    authorities, the
    >file opens. If not, an error message is displayed and it
    is not.
    >
    >You have apparently "joined" or made as your default, a
    workgroup file with
    >a password on the "Admin" user so you are prompted for a
    login EVERY TIME
    >you use Access. Again, what file or files you might
    intend to use does not
    >matter. If you only need to use this particular workfile
    some of the time
    >then you don't want it as your default. Just use the
    workgroup
    >administrator tool to change your default back to a
    workgroup file that
    >doesn't have a password on the "Admin" user (like the
    default System.mdw)
    >and the prompts will go away. You can then create a
    shortcut for your
    >secured file that specifies a different workgroup file as
    a command line
    >argument so you are only prompted when you use that
    shortcut.
    >
    >
    >--
    >I don't check the Email account attached
    >to this message. Send instead to...
    >RBrandt at Hunter dot com
    >
    >
    >.
    >

  • Next message: Taher: "make table query"

    Relevant Pages

    • Re: Workgroup security files.
      ... If I have an employees DB and a press release DB on my ... workgroup file you are using, not the database file you are opening. ... The workgroup either has a password on the "Admin" user or it doesn't. ... and the prompts will go away. ...
      (microsoft.public.access.security)
    • Database on a LAN Drive, but security only works for me
      ... followed these procedures (from Joan Wild): ... When I start access it prompts me for the user & password, ... Created a new Workgroup file associated the DB to that ...
      (microsoft.public.access.security)
    • Re: Log In
      ... used that prompts the user for a user name and password before they can get in. ... indicates that they are not using the correct workgroup file and "not getting ... If you gave them a shortcut, then the "not getting in" problem would indicate ... longer switching them to the correct workgroup file. ...
      (microsoft.public.access.security)
    • Re: Workgroup file connection problem!!!
      ... While it's possible to attach a new workgroup file to Access, ... The shortcut must include the full path to msaccess.exe, ... Doug Steele, Microsoft Access MVP ... I have some question concerning attachments of new users to the database ...
      (microsoft.public.access.security)
    • Re: WorkGroup & Multiple Users
      ... Although they use your workgroup file by ... opening it via the shortcut, if they don't use the shortcut they are using ... > secure mdw") ... and/or the Users Group still has permissions ...
      (microsoft.public.access.security)