User group permission settings

[Jonathan]

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,

 

[Joan Wild]

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.