Table Permissions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way I can prevent users from deleting records from a table? I
want the table to be an user add only - admin only delete. I run a front and
back end system and the users only have access to the back end via forms

thanking you all in anticipation

PMK
 
If they only have access to the backend via forms, then how are deleting
records from a table?

You can just set the allow deletions property of the form to no; or set it
to Data entry - yes and they'll only be able to add records. You can
provide the administrator with a different form.

Otherwise, you'd implement user level security. Security FAQ -
http://support.microsoft.com/?id=207793
 
Back
Top