User level security setting

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)
 
S

Scott McDaniel

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User level security - help needed 1
User Level Security Enquiry 1
Security - Am I missing something? 4
user-level security and splitting database 3
Return the Highest Level Group the Current User Belongs To (?) 2
setting user-level security for fields 0
Hlp - DB security mystery 13
Remove Access Security 1

Top