losing my mind

[Brigitte P]

I converted several secured dbase from A97 by unsecuring the dbases in A97,
converting to A2002, and attempting to resecure them. It all works fine when
I just assign individual securities after joining the workgroup. I'm in the
Admins group, the owner of the objects, and belong to all groups, thus, I
don't get locked out. Group securities also seem to work okay. However, when
I try to run the security wizzard as the final step, all goes wild. My users
keep on getting messages that they don't have rights, and it even locks me
out. Sometimes I'll end up with and mdw sometimes not. What in the world ...
I followed the instructions precise ... repeatendly.
Are my databases secure enough with just setting the rights individually (or
in groups) or can someone get into my databases via a backdoor if they are
not mdw?
Help, I'm on my wits end.
Brigitte P.

 

[Joan Wild]

Hi Brigitte,

I converted several secured dbase from A97 by unsecuring the dbases in A97,
converting to A2002, and attempting to resecure them. It all works fine when
I just assign individual securities after joining the workgroup. I'm in the
Admins group, the owner of the objects, and belong to all groups, thus, I
don't get locked out. Group securities also seem to work okay. However, when
I try to run the security wizzard as the final step, all goes wild.

The above indicates that you are implementing security manually. Why run
the wizard? Do one or the other, not both.

 

[Brigitte P]

Makes a lot of sense to me, and it works. I wonder whi MS Access Security
FAQ and some other similar articles recommend that you run the security
wizard after I set up groups. It's also unclear to me why my securities
don't accept group level securities. It only works when I set up each person
individually (thanks goodness I don't have too many). Maybe I'm looking at
this too complicated, and I will set them up individually, because it does
work. As alway, many thanks for your help.
Brigitte

 

[Joan Wild]

When you say 'securities don't accept group level securities', what makes
you think that?

Do you mean the permissions don't apply when a group member logs in?

I'm thinking you might think they don't apply because you don't see the
permissions checked for the user in the dialog. That won't happen. When
you apply permissions to a group you'll see the check for the group. The
checks show you the explicit permissions. Being a member of a group, the
user's permissions are what's called 'implicit' - no checks will show for
these, but the user will inherit the group's permission.

 

[Brigitte P]

Yes, the permissions don't apply when the user logs in. But as I said, I
have only a few users so I'll apply the securities individually because this
seems to work okay. Once I have my reference manual, I may be able to do
things a bit better. I had the securities set up individually in A97, never
used the wizard. I think this works better for me, even though I like many
of the Access Wizards otherwise. Thanks again for your help. I'll keep on
trying and check in with the group if I get stuck.
Brigitte