Cut paste recordset from one table to another (ADODB)

[prinsr]

Dear all,

I would like to know how I can cut and paste one ADODB recordset from a table to another. A recordset is just one record that is specified by the user. So for example: the user identifies record ID 60 as wrong and wants to delete it. The code should cut the record from Access_Database and paste it into Access_Database2.
I've got the following code so far:

Please Login or Register  to view this content.

Can someone help me with this?

[cytop]

Have a look at the 'INSERT INTO' SQL statement to add the record to the 2nd db, and the DELETE statement to remove it from the first...