Record Locking

[Jose Lerebours]

What do you attribute your record locking issues most often to

A. Two or more users trying to update the same record
B. Running a report while a user is in update mode
C. Rebuilding indexes  while user is in update mode
D. User closed connection leaving a lock file behind
E. Lookup processing that locks but does not release record

To me, (B) was the most common record lock instances till I decided to 
run reports ignoring this and just keep on moving.

I rarely ever heard of two users trying to update the same record - I do 
remember seeing situation where a user will use the arrow up/down and
reach a record where a user was sitting in update mode and the "waiting 
for record to be unlocked ..." came up; even without any processing 
being triggered.

Do not hold me to "even without any processing being triggered" part of 
the above statement but I am at least 80% sure of it.

What about you?  What would be your most frequent reason?


-- 

Jose Lerebours
954 559 7186

https://www.asisuites.com
https://www.helpsuites.com
https://www.cargosaas.com