[AccessD] Audit trail of Deleted record

David Beckles becklesd at tiscali.co.uk
Tue May 2 13:09:19 CDT 2006


Hi, Kevin,
Take a look at these pages from Allen Browne:
http://www.everythingaccess.com/tutorials.asp?ID=Creating-an-Audit-Trail

and
 
http://allenbrowne.com/AppAudit.html

I think that you will find that they cover your problem fairly thoroughly.

Hope that this helps,
David


------------Original Message----------------------
> Date: Mon, 1 May 2006 12:26:45 -0500
> From: "Kevin Bachmeier" <kevinb at bepc.com>
> Subject: [AccessD] Audit trail of Deleted record.
> To: <accessd at databaseadvisors.com>
> Message-ID: <5C210A2F04B76B4AB2A18E6FEB81713404D727C7 at HDQ06.bepc.net>
> Content-Type: text/plain;	charset="us-ascii"
>
> 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
>   




More information about the AccessD mailing list