Take the 2-minute tour ×

I am using Access Database with c# windows application. My application uses different methods to update different tables of database. I want to make my code block transactional but access do not support TransactionScope. Is there any other way of doing this?

My Existing Code sample:

using (TransactionScope scope = new TransactionScope())
                //If customer exists update it else Register new customer
                if (Customer.IsCustomerExists(cname) == true)
                    Customer.UpdateCustomerInfo(cname, cell, mobile, phone);
                    Customer.RegisterNewCustomer(cname, cell, mobile, phone);

                //If source station not exists, Register new station
                if (Station.IsStationExists(source) == false)

                //If destination station not exists, Register new station
                if (Station.IsStationExists(destination) == false)

share|improve this question
What do you mean by "single round trip" and what does that have to do with TransactionScope ? –  Magnus Dec 29 '12 at 22:31
The Jet driver doesn't support transactions. You have to use a different data store. –  casperOne Dec 30 '12 at 15:58
add comment


Your Answer



Browse other questions tagged or ask your own question.