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?

    croy, Aug 31, 2011
    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