I am currently developing a financial application in VB. The ADO control is used to access data from an MS SQL Server database. I use the TABLE.Save command to save any table prior to updating the the table; and restore this saved information to the table in case of error. This method has proven to be inefficient because any power failure will result in some tables being updated and others left out. This is very dangerous in a financial environment.
Is there any method of Roll Back used in ADO that will allow the tables to be updated only when Commitrans is called?
