*.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.
Similar Threads
  1. W. Guy Delaney

    Can access database with either System.mdw or Secured.mdw

    W. Guy Delaney, Jul 3, 2003, in forum: Microsoft Access Security
    Replies:
    5
    Views:
    4,001
    david epsom dot com dot au
    Jul 7, 2003
  2. rick

    Does using system.MDW bypass secure MDW?

    rick, Aug 13, 2003, in forum: Microsoft Access Security
    Replies:
    0
    Views:
    1,063
  3. Joan Wild

    Re: Does using system.MDW bypass secure MDW?

    Joan Wild, Aug 14, 2003, in forum: Microsoft Access Security
    Replies:
    0
    Views:
    952
    Joan Wild
    Aug 14, 2003
  4. Kath via AccessMonster.com

    Security Woes - how to best secure per group per table

    Kath via AccessMonster.com, Jul 21, 2005, in forum: Microsoft Access Security
    Replies:
    6
    Views:
    170
    Joan Wild
    Jul 22, 2005
  5. Cbeckwith

    Copying from a non-system.mdw to the system.mdw

    Cbeckwith, Apr 30, 2010, in forum: Microsoft Access Security
    Replies:
    2
    Views:
    617
    Tom van Stiphout
    May 1, 2010
Loading...

Share This Page