Hi,
Would this
http://www.aspfaq.com/show.asp?id=2191 be helpful?
>Hi All!
>
>i'd like to hear some insights on which better method to use for ADO transactions.
>
>i wrote a short procedure that uses the BeginTrans,CommitTrans and RollBackTrans and uses a SQL Statement to perform database manipulation (select,add,update and delete). However my boss asked me to try the procedure using the ADO methods (ado.addnew,ado.update,ado.delete etc) instead of using a straight sql statement.
>
>i personally prefer the first method (using a straight sql statement) but i was asked to differentiate these 2 methods and recommend which is better.
>
>any insight would really help!
>
>Thanks!
If it's not broken, fix it until it is.
My Blog