Table Permissions

[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

 

[SusanV]

Have you set the form's Allow Deletions property to No? If they are
accessing the tables directly you will have to use security:
http://www.jmwild.com/Accesssecurity.htm

 

[Joan Wild]

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