how do i set a table in the database so that no one but me can delete recodes
but only delete and select?

Hi sushiboy

You would normally not allow anyone to have access to the table to carry out any editing.

This function would normally be set at the Form level with User Permissions

Cheers

Mike

This is true. Users shouldn't be accessing tables. They should only be using forms. Once they are only using forms, then there are multiple options for deletions....

right. the users see the data from forms but I want a rule on the table lvl that stops all deleting.

Hi sushiboy

Again - you would set the Form to allow additions but not to edit/delete

Mike

Better yet, don't allow them to view tables at all. You can mimmick tables on forms...