Locking Records to Prevent Deletion

[Joyce]

I need to lock the records in my table so the files can
not be deleted or altered. What is the best way to
accomplish this that will allow the administrator to
quickly unlock the fields when needed and then relock
quickly.

I appriciate your help, thank you

 

[Scott McDaniel]

You can't "lock" tables unless you implement Access User Level Security ...
you can set .AllowDeletions = False on your forms which would disallow ANY
deletions (and you should NEVER allow users direct access to your tables
anyway, unless you want the unenviable task explaining to your boss why last
year's data is no longer available <grin>), but how do you determine who
can/cannot reverse this function?