User-level security

G

Guest

Hi,
How can I limit user's access to the tables, I don't want the users to be
able to open, even in read-only mode, or create a new one but because my
forms are related to the table they should be able to oull up the data from
tables in forms format.
I tried to use user and group permission option in the security but when I
don't let them to open and run the tables access doesn't let user to retrieve
data out of those tables,
please advice.
Ramtin
 
J

Joan Wild

You can use RWOP (run with owner permission) queries for all data
interaction. Using these, your users don't need any permissions on the
tables. You set this property in the properties dialog for a query while in
design view.

Read more at www.jmwild.com/RWOP.htm
 

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

Similar Threads

Customized access to the database 1
ULS Update/Delete Permissions not working 5
User Level Security 1
User-Level Security 1
User level security - help needed 1
setting user-level security for fields 0
Query Wizard Access 2
Use Level Security lockout 6

Top