[AccessD] Audit trail of Deleted record.

Kevin,

I did something similar a few years ago.  I had 100% control over the 
buttons/forms the user saw...I'm not sure how much access you allow your 
users.  I gave them a delete button...it prompted "Are you sure"...if they 
said yes...it launched an append query to move the record to a new 
table...then a delete query to remove it from the original table.

I later modified this because I didn't really need to move it out of the 
table...I just need to remove it from the user and reports.  I created a 
delete flag in my table...and my delete button then just changed this flag 
to TRUE.  My user forms and reports then used the same data source as 
before...just filtering out any records where Delete_Flag = TRUE.

Hope it helps,

Mark A. Matte


>From: "Kevin Bachmeier" <kevinb at bepc.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: [AccessD] Audit trail of Deleted record.
>Date: Mon, 1 May 2006 12:26:45 -0500
>
>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