transaction with Access 1

[russland]

Hi, I try to apply a simple BEGIN TRANSACTION to my bunch of queries. but it always returns "Invalid SQL Statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'."

Even this simple query fails respectively return the error msg printed above.

BEGIN TRANSACTION
SELECT * FROM PROJECTS
COMMIT TRANSACTION

Any hint on how to use TRANSACTION in MsAccess is highly appreciated. Thanks

 

[mp9]

Do it in VBA, where BeginTrans, CommitTrans and RollbackTrans are all supported, and can be used to bookend other VBA commands to run your SQL (e.g. CurrentDb.Execute or DoCmd.RunSQL)

http://www22.brinkster.com/accessory/

 

[russland]

thanks for that. I'll try. is that for OLEDB or when you choose the MsAccess Driver in your connection string?

However, I'll check if that's supported with ASP.

thanks for now.

 

[russland]

Alright. nameConn.beginTrans, commitTrans and rollbackTrans did the job.

Thanks a lot. Your surely deserve the star