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.

Share This Page