move the records to another table when they are deleted

S

sheela

Hi,

I have posted this message on another post and didn't get
reply. So trying on this post.
I have two tables. 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
 
R

Rick Brandt

sheela said:
Hi,

I have posted this message on another post and didn't get
reply. So trying on this post.
I have two tables. 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.
Click to expand...

You can't. Tables have no events to do this. Users should not be allowed
direct access to the tables anyway.
 
T

Tim Ferguson

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.
Click to expand...

Just don't delete the records. Mark them with a Boolean column called
"Deleted" or "Expired" or something; and flush them only when you know the
_information_ value has definitely gone away.
If somebody directly delete the records o
Click to expand...

Either sack him or her, or (better) make the application so that the users
never get a chance to. Hide the database window or (better) block all
access to the tables, control all data interaction through forms and
reports; or (best) remove permissions using formal Access security.

HTH


Tim F
 
Top