Log delete event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Daniel said:
Hello,

I recently have had a nasty experience with my company's database. A user
Click to expand...
(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
Click to expand...
which will log a user name, table affected, record number each time a delete
occurs?
 
Back
Top