how to prevent accidental deletion in existing records?

[snapjuice]

I am using the contacts list database that was offered through Access 2010.
I would like to prevent accidental deletion on existing records/fields.

How do I prevent edits to a field or a record?

Thanks

[June7]

For starters:

1. Don't let users work directly with tables and queries.

2. Use code to handle when keyboard delete key is pressed.

3. Set form AllowDeletions property to No and control Locked property to Yes.

[aldridge_p]

To add to June's help...

One of the properties available on form controls (Controls are fields, check box's etc) is 'Locked'

You can change the 'Locked' property when the form is in design view. Changing the value of 'Locked' from No to Yes will mean that edits can't be made through that control.

This can be useful when you have certain controls that you want to be 'display only' and certain controls which the user should be able to edit.