I am going through an exisiting Access 2003 application and I am trying to tighten things up to make it more stable and efficient.
Most of the database code (mostly DAO) does not do any confirmations on INSERT and DELETE operations. UPDATES are performed automatically as changes are made. I would like to be able to tell users whether or not a database operation succeeded and I would also like to have more control over transactions in general.
This leads to my question: Is using a TRANSACTION block the best way to do an operation with a confirmation or is better to just re-read the new row and base the confirmation on the success of that operation?