security: user level vs. group level
MS ACCESS, PLATFORM: WINDOWS XP PRO
I have a user (john.doe) as a member of a group (MyGroup). I have
assigned group permission to view and run the queries of that db but
then when I log in with that user, I still can't access the queries.
However, when I change that individual user's permissions to allow
access to the queries it goes through fine and he can access it.
Don't understand what's going on here and certainly don't want to have
to assign indiv permission to every single user in the db. I would much
rather prefer the groups approach.
Thanks in advance for any advice or tips.