[AccessD] How does SQL Server do updates

Precisely my point, Jim. In-situ updates by definition destroy data and
prevent rollbacks; hence the delete-then-insert scenario, without which a
rollback would be impossible. Thus, UPDATE is a glorified term for DELETE
then INSERT. No other way to make it all work. Nuff said,,, or perhaps for
the sake of performance you would prefer to sacrifice RollBack.

A.