Re: TRANSACTION

hello, we had the same problem. i think its is the ODBC who takes some initiatives behind your back. we solved the problem by calling explicitly the begin transaction for the odbc and for informix. it gives something like this : Public myConnect As rdoConnection Public Sub BeginTrans() myConnect.BeginTrans myConnect.Execute "BEGIN WORK" End Sub Public Sub CommitTrans() myConnect.Execute "COMMIT WORK" myConnect.CommitTrans End Sub Public Sub RollbackTrans() myConnect.Execute "ROLLBACK WORK" myConnect.RollbackTrans End Sub philippe