Record Table Alteration

[Earl C Phillips]

I am a volunteer programmer in a regional food bank to feed the hungry. I wrote a volunteer-scheduling application to keep track of the 4000 volunteers every month. Someone is altering the tables directly rather than through the forms. How can I capture the delete event directly too a table or row and capture who is doing it, or stop the deletion? I have a function that captures the ID of whoever is in the system but cannot figure how to capture the event procedure for when a table or row is deleted. When I find out how, I will write the record and the ID doing it to a journal file to capture their identity.

I already have a journal in place for creations and deletions of records from within the forms. Any suggestions would be appreciated.