Hi,<BR><BR>I using the concept of transactions for updating records. I&#039m using the AddNew method of the RecordSet object to add a new record to a table. For the following code, will the AddNew method come under the transaction management support? As far as I can see, it will not, so how do I ensure that the AddNew method is under the transaction management support?<BR><BR>Set objDatabase = Server.CreateObject("ADODB.Connection")<BR>objData base.Open Application("strDatabase")<BR><BR>objDatabase.Begi nTrans<BR>Dim RS<BR>Set RS = Server.CreateObject("ADODB.RecordSet")<BR><BR>&#03 9 Add a record to the table<BR>Rs.Open tableName, Application("strDatabase"), adOpenKeyset, adlockoptimistic<BR>RS.AddNew<BR>...<BR>...<BR>RS. Update<BR>RS.Close<BR><BR>...<BR>...<BR>objDatabas e.CommitTrans<BR><BR>Thanks in advance,<BR><BR>With Regards,<BR>Anuj<BR>