PC Review

Thread Tools Rate Thread

Changing MDW File (?)

Posts: n/a
      31st Aug 2011
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?

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying from a non-system.mdw to the system.mdw Cbeckwith Microsoft Access Security 2 1st May 2010 04:47 AM
Prevent changing *.mdw file J.A. Microsoft Access Getting Started 3 23rd Aug 2004 10:45 PM
Re: Does using system.MDW bypass secure MDW? Joan Wild Microsoft Access Security 0 14th Aug 2003 12:06 AM
Does using system.MDW bypass secure MDW? rick Microsoft Access Security 0 13th Aug 2003 09:07 PM
Can access database with either System.mdw or Secured.mdw W. Guy Delaney Microsoft Access Security 5 7th Jul 2003 10:23 AM




All times are GMT +1. The time now is 06:31 AM.