move the deleted records to another table

From: sheela (anonymous_at_discussions.microsoft.com)
Date: 07/09/04 

Date: Fri, 9 Jul 2004 07:11:32 -0700

Hi,

 My apologies if i am posting this question in a wrong
place. If so please advice me.
I have two table. First one is main table. If any record
is deleted from this table using a form, the record will
be moved to the second table. So that we can keep track of
all the deleted records.
If somebody directly delete the records on the table (
with out using a form), this won't work. How do we move
the deleted records from a table to another table, before
they get deleted.
Thanks for any hints.
Sheela

Relevant Pages