Locking of individual records in a table?

Hi group.

Is there a way of locking individual records in a table, so that they cannot
be altered og deleted before first being unlocked ?

I already have a boolean field called "Locked' in my tables, but that
doesn't prevent somebody (or my app:-) from accidently deleting record.

Actually I have a problem right now with records mysteriously disappearing
from my tables, and I think it's probably a softway bug. So it would be nice
to be able to lock records, so that there is an exception when a record is
attempted deleted.

I use MS Acces, and maybe some day SQL Server.

Thanks for your help!
Jacob


.