Which ADO object is used to perform commit / rollback ?
Is it command or connection or recordset

I am not sure of the options given. So please let me know
the answer if it is something else.

Answer Posted / ghanshyam vrema

ye, through Connection object you can commit or rollback
the transaction Eg:

on error go to errhandler
con.BeginTrans

con.execute cmd
con.execute cmd2
con.CommitTrans
errhandler:
con.RollbackTrans

Is This Answer Correct ?    18 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ODBC Direct and Microsoft Jet Database Engine ?

2092


Explain the working of templates?

777


How do I do drag & drop between applications?

1221


How do I call help files from a VB program?

1195


Is it possible to Access BackEnd procedures?

1802


Why do I get "object not an array" when I try reference the fields of a global object variable which I have set to a table?

1380


What is OLEDB?

1760


DHTML Is used for what?

1662


Write the Steps in Creating an ActiveX Control?

1710


How do I implement an accelerator key for a text box?

1260


How would you access objects created in ActiveX Exe and ActiveX Dll

1755


Draw Sequence Modal of RDO and Explain?

2095


Difference between Class Module and Standard Module?

2182


Explain the working with task in Gantt chart view.

835


How would you create properties in ActiveX Control?

1715