When I do updates in a connection.BeginTrans and Connection.CommitTrans, the application behaves very erratically, but without the transaction it behaves perfectly.

reConnApp.BeginTrans
ret = StartSheetSave("SAVE")
if dbUError = false and ret = true then
reConnApp.CommitTrans
Session("REDBUERROR") = false
else
reConnApp.RollBackTrans
end if