Jul 24 2007, 07:49 AM
how do i set a table in the database so that no one but me can delete recodes
but only delete and select?
Jul 24 2007, 08:00 AM
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
Jul 24 2007, 08:20 AM
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....
Jul 24 2007, 08:32 AM
right. the users see the data from forms but I want a rule on the table lvl that stops all deleting.
Jul 24 2007, 11:27 AM
Again - you would set the Form to allow additions but not to edit/delete
Jul 24 2007, 11:53 AM
Better yet, don't allow them to view tables at all. You can mimmick tables on forms...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here