Does Access DB supports transactions?

[thelordoftherings]

Hello,

I have an ASP page connected to an Access DB.
Through the ASP I am making updates using transactions.
My question is if an Access DB supports transactions at all (meaning rollback and commit)?

 

[KenReay]

In a word yes, see BeginTrans and Commit methods of workspace object for how you would do it in DAO, there are presumably similar methods in ADO, as properties of the .Connection object(?), but I am not familiar enough with ADO to quote them

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[BNPMike]

With OLE DB/ADO you can issue plain SQL:

BEGIN TRANSACTION
ROLLBACK TRANSACTION
COMMIT TRANSACTION

 

[Ed2020]

Yes, the ADO connection object has .BeginTrans and .CommitTrans methods.

Ed Metcalfe.

Please do not feed the trolls.....