[AccessD] Audit trail of Deleted record.

You may find a concensus here of people who do not delete records but
put a flag on them so they're hidden from users.  You could then simply
track who deleted a record and when (unless space is an issue and you
really want the records gone). 

HTH,

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kevin
Bachmeier
Sent: Monday, May 01, 2006 1:27 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Audit trail of Deleted record.

I am trying to find a means of auditing the deletion of records from a
table (write a record in another table with the appropriate details of
who, when, and key fields of the record being deleted).  

My attempt at using the BeforeDelConfirm event fails as the values of
the form's fields of this bound form are already null (deleted).

I was able to find some discussion of auditing changes to records in the
archive, but am not able to find anything on deleted records.

Anyone with some experience or suggestions on obtaining the values of a
record once the user has selected the record and pressed Del, or
selected Record Delete?

Thank you in advance.
Kevin
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com