Users allow read only of tables

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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.
 
Back
Top