>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.
I've noticed strange thing, which I'm going to investigate. If I have Auto-Suspect record (marked in red in the grid), I immediatelly get an Error message attempting to make changes in this record. But once I Accept it (make it blue and change status to manually-resolved), I'm able to make changes. Accept button fires replace command and then tableupdate. Once I did it, I'm able to change the record...
If it's not broken, fix it until it is.
My Blog