Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Regarding MTS and MS-ACCESS

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
Here I want to take advantage of MTS in my asp pages.
There are 4-6 big queries being executed one after the another.If some errorneous condition happens,i want to
copletely roll back and unsave changes if happened.

"So if executes all 5 queries executes or none" is my motto.
Can I use MTS using MS-ACCESS as back end ??

Regards,
shroff_rushi@rediffmail.com
 
you can use mts with access. it has a limitaion that you cant use transactions with more than 1 DB ( as you can with sql-server or oracle).

you can also use transactions withuout mts, with ADO (if con is adodb.connection, use con.begintrans con.committrans con.rolbacktrans) it is more simple in your case i think.
 
Right but,
I read that JET(Access) doesnt support transactions(MTS) ?
 
the best thing to do is check.
im sure that the jet supports transactions(you dont nead mts for it), because i did it about a milion times.

im almost sure, that you can use transactions with access and mts, but check it, it will take you 5 minutes.

what i am sure is that the jet does not support distributed transactions with mts, involving other databases, such as sql server or oracle. this is a limitation
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top