Log delete event

[Daniel]

Hello,

I recently have had a nasty experience with my company's database. A user (unknown) has delete a great number of records causing me to try and recorver them (they were deleted over a period of time making hard to locate each delete entry ....)

My question is:
Is there a way for me to automatically create a log entry into a table which will log a user name, table affected, record number each time a delete occurs?

Thanking you in adavance,

Daniel

 

[solex]

Not with access, if the user has the ability to delete then they can delete
from a form or directly from the tables. If the user is not savy and does
not know how to delete from the tables then you could create a log in the
OnBeforeDeleteConfirm event.

Other then that you could move to SQL server where you have a delete
trigger.

Dan

Hello,

I recently have had a nasty experience with my company's database. A user

(unknown) has delete a great number of records causing me to try and
recorver them (they were deleted over a period of time making hard to locate
each delete entry ....)

My question is:
Is there a way for me to automatically create a log entry into a table

which will log a user name, table affected, record number each time a delete
occurs?