How can I copy a user group?

[Paul Harrold]

I have a quite complex DB. I need to create 8 different user groups, for my
16 users. Creating groups will be extremely time consuming due to the amount
of tables/queries etc.. in the database.

Now I know most people would recommend I create several groups and assign
each user to more than one group to give them their desired permissions. OK
that makes sense, but it will be harder to manage when objects are added to
the DB or security requirements change. So I would much rather work with 8
distinct though similar groups, so that I will not need to concern myself
with the "knock on" effects of changing permissions in one particular group.

So can anyone tell me how to copy a user group?

I have scoured the web and the NGs and can't find any info on this!

Thanks,

Paul

 

[Joan Wild]

You don't mention the version, but you should be able to modify the code in
DbUtilities at
http://www.daiglenet.com/MSAccess.htm

to do this.

 

[Paul Harrold]

Many thanks Joan,

I am a little confused by this code as it only grabbed permission info from
the "Admins" and "Users" groups. Here is what I did:

I used previously secured database and added the "Admin" user back in to the
"Users" group so that the code could access this DB without error. I
imported the "$tblPermissions" to this database and ran the
"DumpPermissions" procedure. The output to the "DumpPermissions" table only
contained info on the "Admins" and "Users" groups, even though several other
groups have permissions set on the databases objects.

What did I miss?

Thanks,

Paul

P.S i am using Access 2000 :O)

 

[Paul Harrold]

Joan,

I finally got it to work, what a lovely bit of code! Is it your own?

Either way, many thanks for your help, you have saved me a lot of time and
anguish :O)

Regards,

Paul

 

[Joan Wild]

Joan,

I finally got it to work, what a lovely bit of code! Is it your own?

Nope. That site belongs to Sandra Daigle, another Access MVP.