Removal without deletion

Hi,

How do I remove a record from a recordset without actually deleting it from the actual database itself?

I am using the Delete method.

Thanks in advance.

Copy the data to another table:

insert into table2
select * from table 1
where unique_condition

delete from table2 where unique_condition