hi friends

i have vb.6 app. and in this app. i can delete ,select, update the records in database ms access .

so if i delete a record and i want to roll back it what to do here.

what is the query to rollback any deleted records.

for ex:

i have two table A and B so when i insert a record into A
and when insert into B table it deleted from table A

so here if i delete from table B it restor the same record to TABLE A.

THANK U. BYE