|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
I assign user and group by user-level security wizard like these
Group User
Admins Admin
Full data user AAAAA, BBBBB, CCCCC
New data user DDDDD
and then I try to use user and group permission to limit some permission of
CCCCC
to open some forms by click open/runin permission box to deselect form.
I have Form1, Form2,,,,,,,,,,, Form10
I try to deselct Form6 and Form7
After I log on in name of CCCCC, I still open form6 and form 7 like user
AAAAA and BBBBB, Why am I wrong ?
|
|
First, Admin should not be a member of the Admins Group. You should create
a new user to be a member of Admins, and remove Admin from that group.
You likely assigned permissions to the CCCCC user. However they are still a
member of the 'Full data user' group, and therefore have the permissions for
that group. Permissions that a user inherits from a group do not show up in
the security dialogs. Only explicit permissions show for the user.
You'd need to create a separate group that doesn't have permission on Form6
and 7 and make CCCCC a member of that group.
--
Joan Wild
Microsoft Access MVP
Nova wrote:
[Quoted Text] > I assign user and group by user-level security wizard like these
>
> Group User
> Admins Admin
> Full data user AAAAA, BBBBB, CCCCC
> New data user DDDDD
>
> and then I try to use user and group permission to limit some
> permission of CCCCC
> to open some forms by click open/runin permission box to deselect
> form.
>
> I have Form1, Form2,,,,,,,,,,, Form10
>
> I try to deselct Form6 and Form7
>
> After I log on in name of CCCCC, I still open form6 and form 7 like
> user AAAAA and BBBBB, Why am I wrong ?
|
|
Thankyou for your answer but I have a new problem in assign new user.
I create a new group (GPNew) by menu users and group account then create new
user (EEEEE) in GPNew after that I cannot log on to database in user name
EEEEE, I don't know why?. But I can log on by others user name normally, but
if I remove user AAAAA,BBBBB or CCCCC form full data user group and then put
in GPNew group I cannot log on to database why? and Where am I wrong?
|
|
When you create a user via the Tools, security, Accounts menu, you supply a
username and PID. The PID is not a password.
Try logging in as the new user with no password.
(You can then set a password for the user via the Tools, security, Accounts
menu.
You created the earlier users via the security wizard, which does offer the
opportunity to set a user password.
--
Joan Wild
Microsoft Access MVP
Nova wrote:
[Quoted Text] > Thankyou for your answer but I have a new problem in assign new user.
>
> I create a new group (GPNew) by menu users and group account then
> create new user (EEEEE) in GPNew after that I cannot log on to
> database in user name EEEEE, I don't know why?. But I can log on by
> others user name normally, but if I remove user AAAAA,BBBBB or CCCCC
> form full data user group and then put in GPNew group I cannot log on
> to database why? and Where am I wrong?
|
|
Thank you for our answer. I can log on
|
|
|