Replacing Access Workspaces with ?? (1 Viewer)

[ian_w]

I have various routines that run in workspace transactions in VBA using DAO.

I've just figured out that these are no longer working now I have ODBC linked SQL tables :banghead:

What is the SQL alternative to an access workspace to allow rollback if an update fails? Can it be done from access VBA or do I have to do this on the SQL server itself?

 

[SQL_Hell]

In SQL server, check out TRANSACTIONS

An example is here:

http://stackoverflow.com/questions/3935900/how-to-commit-and-rollback-transaction-in-sql-server

 

[Christos99]

Hi,

You can still do it from VBA using ADO instead of DAO.
Check out the BeginTrans, CommitTrans and RollbackTrans methods.

Cheers,
Chris