Hi,

I understand how begintrans / commit and rollback work from VB6 but is it possible to use it if I am using the oledbcommandbuilder to populate my dataset and when I do updates. I am writing a routine which updates several tables and I only want this to be completed if all updates were successful. Here is how I populate my dataset:-
Code:
        sSQL = "SELECT * FROM TO_TRAINING_AND_OPERATING_ITEMS WHERE TO_REFNO = " & Me.tdgMain.Columns("TO_REFNO").Text
        oleDACurrentTOOP = New OleDbDataAdapter
        oleDACurrentTOOP.SelectCommand = New OleDbCommand(sSQL, oleDCData)
        oleDSCurrentTOOP = New DataSet
        oleDACurrentTOOP.Fill(oleDSCurrentTOOP, "TO_TRAINING_AND_OPERATING_ITEMS")
Many Thanks,

Jiggy!