User level security setting

  • Thread starter Thread starter Ching
  • Start date Start date
C

Ching

Dear Friends,

I have problem to set user level security in Access 97.
The situration is:
I have create a user "ABC", it belongs to 2
groups "Users" and "Managers".
Only Managers group is allow to preview "report A" but
other groups is not allow. So I set Run Permission
to "Managers" group only. Run permission for "Users"
group and "ABC" user is unchecked! But I found that the
outcome is not as expected! "ABC" user still can't
preview "report A".

Question:
-Do my user level security setting correct?
-is it related to the changing of the self define .mdw
during run-time? (Coz original is point to system.mdw)
 
Users should really belong to only one group. If you place users in more
than one group they will inherit the least restrictive permissions, and you
will end up with issues such as this. Remeber that ALL users belong to the
Users group (and they cannot be removed from that group), so give
permissions to that group sparingly.

How are you opening your database? Are you joining your workgroup and then
opening, or are you opening your database by a shortcut? Are you prompted
for a username/password when opening your database?
 
Back
Top