Changing MDW File (?)

Discussion in 'Microsoft Access Security' started by croy, Aug 31, 2011.

  1. croy

    croy Guest

    When we first set up our database, we used the built-in User
    Level Security. We wanted that because we had to use a
    sneaker-net to a remote office, and didn't want anyone there
    to accidentally destroy anything.

    After some problems with the remote user's not being able to
    do what they needed, management made a knee-jerk reaction,
    and said to give the remote-office personnel full admin
    permissions to the entire db.

    After a few years of trouble-free use, management has now
    made two decisions:

    1. To have our IT dept. set up the remote office front-end
    to link directly to our home-office back-end (instead of
    doing manual, monthly appends at the home-office).

    2. Set up some sort of mechanism such that the
    remote-office personnel cannot alter records after a
    yet-to-be-determined amount of time.

    Since the remote office has a copy of the original MDW file,
    I'm assuming that I'll need to shift the mdb over to a
    different MDW file. Is that correct?

    If I'm on the right track here, can I just make a copy of
    the existing MDW, rename it, open the mdb and use the
    Workgroup Administrator to set the mdb to use the new MDW?
    Then alter the User/Group assignments to suit?

    This is using MS Access 2002 on WindowsXP machines.

    Is my plan good?

    --
    Thanks,
    croy
     
    croy, Aug 31, 2011
    #1
    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. sweeneysmsm

    Need Syntax for Shortcut to .mdb file with .mdw file

    sweeneysmsm, Jun 26, 2003, in forum: Microsoft Access Security
    Replies:
    10
    Views:
    1,494
    Jack MacDonald
    Jun 28, 2003
  2. 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:
    3,900
    david epsom dot com dot au
    Jul 7, 2003
  3. rick

    Does using system.MDW bypass secure MDW?

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

    Re: Does using system.MDW bypass secure MDW?

    Joan Wild, Aug 14, 2003, in forum: Microsoft Access Security
    Replies:
    0
    Views:
    896
    Joan Wild
    Aug 14, 2003
  5. Cbeckwith

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

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

Share This Page