Buzby

Are you processing a lot of records then commiting the transaction.

If you try commiting the transaction after each record rather than a full set of records. This way you know each record is updated rather than hitting an error part way through a recordset an not updating any thing at all