Move Database Record from one Table To another using a Recordset.

[SKM]

Hello.

I need to know how to move a record in an Access Database from one table to another table (in the same database) where the Fields in both tables are the same using a Recordset,

Any help would be much appreciated,

Thanks
SKM

[Dnereb]

Basicly it's simple copy the data to the destinationtable and delete it from the sourcetable.

But I wonder why do you want to use a recordset and what kind ADO or DOA

And if you want help coding you need to tell more about these tables (Names and Field names) and what kind of database you are using.

and if possible your code to achieve this task

[SKM]

From my Application I need to be able to Delete a database record but still keep a copy of it elsewhere so I was going to move the record to another table as a backup copy. To do this I thought I would need to use a ADO Recordset.

A few more details, no code done yet as i'm still trying to work it out but the main table is named tbl_Master and the backup table is called tbl_Delete, these two tables both contain the same Fields and are both in the same Access 2000 database named SKM_ICE Dbase.mdb.

I hope this is enough info for you to help me.

Thanks,
SKM

[Dnereb]

Unless you have a good reason DAO should be preffered with Access becauce it is the native recordtype for Access.
And did you consider using SQL instead of recordsets

There are stil some things missing
on what base do you identify your record (it's Id or something else)
and the field names would be handy.