I am online shoping system in ASP and backend is MS Access. In a page i am executing More than one SQL. if any one SQL aborts, Other Sql Should not COMMIT.
Regards,
Murugesan
Use ADO and use the connection object and set it transactions on the Command object. If it fails then issue the RollBack command, and if all succeeds then issue Commit.
James James Culshaw
jculshaw@active-data-solutions.co.uk
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.