Allow User to Run/Save queries

C

Chaplain Doug

You need to activate user level security on your
database. This allows you to set permissions by user and
by group. Thus, you could keep people from designing (or
modifying the design) of tables, forms, and modules. User
level security is set uder Tools-Security. It will take
you a little time to become familiar with this security
tool, but it will be worth the time and much better than
trying to do it programmatically.
-----Original Message-----
Is there a way to programatically or otherwise to let
users have access to the "Queries" and "Reports" tabs in
the database window while not allowing access to "Tables"
and "Forms" tabs???
I want to let users create, save, and run queries and
reports but I don't want them to touch the tables,
modules, and forms.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top