Users allow read only of tables

G

Guest

I am creating a database for users to submit information from forms into
tables. I have the information linked to each indivual user by utilizing the
CurrentUser() function. I would like the users to be able to read the table
but not be able to edit/add/delete information without going through the
form- therefore each entry is secured to each individual. Is this possible?
 
J

Joan Wild

You can grant read data permission on the tables. For your form, create a
RWOP query, and grant the insert/delete/edit permissions on the query.
 

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