*.mdw per database

Discussion in 'Microsoft Access Security' started by tsluu, Apr 29, 2009.

  1. tsluu

    tsluu Guest

    How do I implement a security workgroup *.mdw for each database so that when
    a user logs into a database, the related security workgroup comes into effect
    rather than the normal default one, system.mdw. Reason being, a user might
    have individual access rights according to which database they are loggin
    into.
     
    tsluu, Apr 29, 2009
    #1
    1. Advertisements

  2. Create shortcuts to each database, with each shortcut including the path to
    the appropriate mdw file. (There's no other way, since you need the mdw file
    before any code starts running)

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


    "tsluu" <> wrote in message
    news:...
    > How do I implement a security workgroup *.mdw for each database so that
    > when
    > a user logs into a database, the related security workgroup comes into
    > effect
    > rather than the normal default one, system.mdw. Reason being, a user might
    > have individual access rights according to which database they are loggin
    > into.
     
    Douglas J. Steele, Apr 29, 2009
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page