Access, ASP +transaction

[DanBWeb]

Hi all -

Am using an Access database for a small e-commerce site. I want to know if Access can support the transaction functionality in ASP.

I have a situation where I am running 2 inserts. If the second fails, the first needs to be rolled back - can ASP and access handle this?

Dan B

[katocan]

of course they can.

[DanBWeb]

My impression was that Access was not transactional and therefore it would not work - only with SQL, etc

[duckhunter]

Wouldn't really recommend stretching Access to these type of limits. It's hard enough just trying to get more than 1 read to happen at a time.

Performing Transactions with the Microsoft Access 7 ODBC Driver [msdn.microsoft.com]