Jonathan wrote:
> 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?
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.
--
Joan Wild
Microsoft Access MVP
Similar Threads
