UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> access table rules    
 
   
sushiboy
post Jul 24 2007, 07:49 AM
Post #1

UtterAccess Veteran
Posts: 447
how do i set a table in the database so that no one but me can delete recodes
but only delete and select?
Go to the top of the page
 
+
mike60smart
post Jul 24 2007, 08:00 AM
Post #2

UtterAccess VIP
Posts: 8,462
From: Dunbar,Scotland
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
Go to the top of the page
 
+
njonsie
post Jul 24 2007, 08:20 AM
Post #3

UtterAccess Guru
Posts: 823
From: Midwest
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....
Go to the top of the page
 
+
sushiboy
post Jul 24 2007, 08:32 AM
Post #4

UtterAccess Veteran
Posts: 447
right. the users see the data from forms but I want a rule on the table lvl that stops all deleting.
Go to the top of the page
 
+
mike60smart
post Jul 24 2007, 11:27 AM
Post #5

UtterAccess VIP
Posts: 8,462
From: Dunbar,Scotland
Hi sushiboy

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

Mike
Go to the top of the page
 
+
njonsie
post Jul 24 2007, 11:53 AM
Post #6

UtterAccess Guru
Posts: 823
From: Midwest
Better yet, don't allow them to view tables at all. You can mimmick tables on forms...
Go to the top of the page
 
+
« Next Oldest · Access Tables + Relationships · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 22nd May 2013 - 08:09 AM