Delete Button

[Haynesey]

Hi,

Is there any way to stop users of a database deleting records once created?

Thanks in advance

Lee

 

[SQL_Hell]

Yes they are called object permissions, do you have user logins?

Also form properties are worth looking at too, like 'Allow Deletions'

 

[doran_doran]

Why even put a delete button ?????

Why even put a delete button if you dont want user to delete records ?

Assuming you are controlling your data via Forms, not tables.

I have a delete button on my form and it's only for managers. You can use delete button and password protect it.

Regards
Dianna Goldsberg

 

[ghudson]

Did you disable the forms Allow Deletions property? If not, then the user can delete the selected record just by pressing the delete key on their keyboard [unless you have also trapped for the pressing of the Delete key].

Me.AllowDeletions = False

Keyboard commands:

Select current record: Ctrl + Shift + Space Bar
Select all records : Ctrl + A

Press the Delete key to delete the selected record(s).
Press the Ctrl + X key to delete the selected record(s).