SQL Server Transaction ??

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 .

I'm having trouble understanding your question, but I can tell you that you should be doing something like this:

VB Code:

objconn.begintrans
 
' code here
' more code
 
objconn.committrans