I normally set up a error handler for record locks. It will retry an update for at least 30 seconds. After that, I will alert the user, log the error and either shut the program down or cancel the update and let the user start over.
Randy Belcher
AFG Industries, Inc.