Is this possible (ADO and MS Access)<BR>I need to delete a record from one table but would like to archive the record in another table at the same time.
Well, there's no such thing as 'move' in T-SQL. You would have to do it in two steps. First a insert in the 'backup' table, then the delete from the other table.
Thanks Dutch, I suspected as much.<BR><BR>Jay