User group permission settings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jonathan - 09 Sep 2004 14:48 GMT

Hello,
I want to create an Access user group in such a way that anyone in this
group will be able to open and run any query, form or report in the database
but not modify them or create any new ones. I establised a group Full Data
Users and assigned no permissions for <New Tables/Queries>. I did this for
forms and reports also. When I log in as a user in this group I'm stopped
from modifying current queries, etc. but not from creating new ones. How do
I prevent this?

Thanks,

Signature

Jonathan
KingsKinght1 <at> hotmail <dot> com

Reply to this Message

Joan Wild - 09 Sep 2004 23:13 GMT

> Hello,
> I want to create an Access user group in such a way that anyone in
[quoted text clipped - 4 lines]
> as a user in this group I'm stopped from modifying current queries,
> etc. but not from creating new ones. How do I prevent this?

The permission you set for the New Tables/Queries doesn't affect their
ability to create new objects. The permissions are applied to any new
objects that are created. A user can create an object, and since they are
the owner, they have full permissions.

There is code in the security FAQ (section 24) you can use to prevent them
from creating new objects.
http://support.microsoft.com/?id=207793

You can also consider locking down your application a little more, so that
they don't have access to the database window. Also create custom
toolbars/menubars.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message