I developed two databases and now I want to join them together using the same
workgroup. The workgroup names are as follow: ApplicationUsers (ReadWrite),
ReadOnlyUsers. The problem is that a user in database A has applicationUsers
permission but that same user only has ReadOnlyUsers permission in database
B. Since they are joined by the same workgroup, whatever permission I
granted the user in database B will effect the user in database A.

I don't want to create two separate workgroup this. How would you handle
this situation. Please help.

"boardrider" <(E-Mail Removed)> wrote in message
news:7A30D0AC-19DD-4467-8E47-(E-Mail Removed)...
>I developed two databases and now I want to join them together using the same
> workgroup. The workgroup names are as follow: ApplicationUsers (ReadWrite),
> ReadOnlyUsers. The problem is that a user in database A has applicationUsers
> permission but that same user only has ReadOnlyUsers permission in database
> B. Since they are joined by the same workgroup, whatever permission I
> granted the user in database B will effect the user in database A.
>
> I don't want to create two separate workgroup this. How would you handle
> this situation. Please help.

You need more groups. Groups need to be defined "per app", not per workgroup
file.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

You need to grant permissions by GROUP, not by the USER. If USER1 is a
member of ApplicationUsers, then USER1 will have all the permissions for
that group. To deal with the separate databases, you will probably need an
ApplicationUsers_A and an ApplicationUsers_B and same thing for the Read
Only users. Keep in mind that a user can be a member of more than one group
and will get the least restrictive permissions of all the Groups that user
is a member of.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"boardrider" <(E-Mail Removed)> wrote in message
news:7A30D0AC-19DD-4467-8E47-(E-Mail Removed)...
> I developed two databases and now I want to join them together using the
same
> workgroup. The workgroup names are as follow: ApplicationUsers
(ReadWrite),
> ReadOnlyUsers. The problem is that a user in database A has
applicationUsers
> permission but that same user only has ReadOnlyUsers permission in
database
> B. Since they are joined by the same workgroup, whatever permission I
> granted the user in database B will effect the user in database A.
>
> I don't want to create two separate workgroup this. How would you handle
> this situation. Please help.