VB Forum / Database Access / June 2003

Hi all,

 i have this problem when I do a transaction, see the code:

on error goto e
conection.begintrans
recordset1.updatebatch  ' until here the Recordset's status is 1 (new)
recordset2.updatebatch
conection.committrans
exit sub
e:
conection.rollbacktrans ' when appears a error the status don't return its
original value '1' , it is equal '8' (unmodified).

That situation cause problems when i try to save again because now it
attempt update and dont insert.
help me please!!

Thanks !
Mariano