SQL Transaction question

[Mazdaspeed6]

Can i run a Begin Transaction command using VBA, run a few other commands than, run a Commit/Rollback command, all as separate commands. Will that have the same effect as a SQL script with a BEGIN TRANSACTION at the beginning and COMMIT/ROLLBACK command at the end?

[weekend00]

you can use transaction process in DAO or ADO.

[Mazdaspeed6]

Ok, but would something like this work

tran.CommandText = "BEGIN TRANSACTION"
tran.Execute

cmd.CommandText = "Some query here"
cmd.Execute

cmd2.CommandText = "Some other query here"
cmd2.Execute

com.CommandText = "COMMIT"
com.Execute

Not taking into account that this would not compile, would something like this that was coded properly work using ADO

[weekend00]

I don't think so.
I think transaction can be used in recordset of DAO/ADO. you can get help from accss help about transaction.

[Mazdaspeed6]

I found an example here - http://www.java2s.com/Code/VBA-Excel...lbackTrans.htm

Like you said weekend00, it is used with recordset.

I found another example of it being used without a recordset http://www.java2s.com/Code/VBA-Excel...ertRecords.htm

Thanks