When transaction is active and one open a recordset.Is transaction is auto commited ? In my case when i commit trans
i get error stating there is no 'begin trans' active. I have opened 2 recordset with in transacton using ado. Same error occured when trans rolledback.

Any one have clear view what to do or not do when a transaction is active.

Which method is best to start a transacton -

a).BeginTrans method of connection object OR
b).'Begin Trans' statement of sql server

Can i use recordset addnew method and insert statement with in a same active transaction .