[AccessD] How does SQL Server do updates

John,

SQL Server doesn't ever physically update a row, but instead does an insert
and a delete. This can be verified by creating a trigger For Update, inside
which you'll find the tables #inserted and #deleted. In #inserted you'll
find some of the original row's columns, with new values for the columns
you changed. Then SQL deletes the row(s) in #deleted, and inserts the
"replacement" rows in #inserted.

HTH,
Arthur