Copying a database, how do I change security?

[David Portwood]

I have a split app (developed using A2000) which my own office has been
using for several months. Another office has recently asked me to make a
copy for their use. I am happy to do so, however, both the FE and BE are
fully secured and I'm not sure how to change security on the copies to
recognize the personnel at the other office and to stop recognizing the
personnel at my office.

I confess that I never fully understood Acess' user level security process.
I implemented security originally by following specific steps from a
textbook which I no longer have. I do understand about granting permissions
for objects and creating accounts and user groups, but somehow the big
picture does not come into focus for me. And I remember being warned against
using the Security Wizard, which every textbook I skimmed in the bookshops
today seems to recommend using.

I would appreciate all the help I can get, many thanks in advance.

 

[Rick Brandt]

I have a split app (developed using A2000) which my own office has
been using for several months. Another office has recently asked me
to make a copy for their use. I am happy to do so, however, both the
FE and BE are fully secured and I'm not sure how to change security
on the copies to recognize the personnel at the other office and to
stop recognizing the personnel at my office.

I confess that I never fully understood Acess' user level security
process. I implemented security originally by following specific
steps from a textbook which I no longer have. I do understand about
granting permissions for objects and creating accounts and user
groups, but somehow the big picture does not come into focus for me.
And I remember being warned against using the Security Wizard, which
every textbook I skimmed in the bookshops today seems to recommend
using.
I would appreciate all the help I can get, many thanks in advance.

Make your copies and then open each one as a user with administrative
permissions. Grant full permissions on all objects to the Users group. These
copies should now be usable for anyone using any workgroup file.

If you want to be more thorough, then open Access using a non-secure workgroup
(no login prompt). Create two new files and import into each of them all of the
objects from the respective copies made previously. Those files will be
identical to files where security was never applied.

 

[David Portwood]

Make your copies and then open each one as a user with administrative
permissions. Grant full permissions on all objects to the Users group.
These copies should now be usable for anyone using any workgroup file.

If I did this, wouldn't I destroy security on the original app? I'm
expecting that I'll need to make a copy of the .mdw file. Is this not true?

If you want to be more thorough, then open Access using a non-secure
workgroup (no login prompt). Create two new files and import into each of
them all of the objects from the respective copies made previously. Those
files will be identical to files where security was never applied.

I don't want to let everyone use the copies. I have an existing security
arrangement, consisting of three groups of users. On the copies, I want to
include the personnel from the other office into these groups and remove the
personnel from my own office.

 

[Rick Brandt]

expecting that I'll need to make a copy of the .mdw file. Is this not
true?

Not at all. These are copies. How could doing something to them do anything to
the originals?

I don't want to let everyone use the copies. I have an existing
security arrangement, consisting of three groups of users. On the
copies, I want to include the personnel from the other office into
these groups and remove the personnel from my own office.

Then you do need to copy the MDW as well as the other files. Then while logged
into the copied MDW remove all users currently in there and add the new ones.
In other words, do what you would do if one person quit and a replacement was
hired. Do that same thing to everyone.

 

[David Portwood]

Then while logged into the copied MDW remove all users currently in there

and add the new ones. In other words, do what you would do if one person
quit and a replacement was hired. Do that same thing to everyone.

Yes! This I understand. Thanks, Rick.