In a shared db, what action locks a record beyond a user having made a change to a record without having yet saved or moved to another record?
I currently have a file with 3 users having it open, yet I have 5 records locked. The locked record dialog shows the record numbers, but no User Name or Computer.
Normally there should never be more than one record locked per user. However, I think it might be possible if a client locks the record and then either loses the connection to the server or crashes. There is a feature that allows the server to handle these situations.
If you have the Auto Lock Timeout feature enabled, I’m not sure if you might still be able to have it indicate that more records are locked than the number of users. The documentation says that if this feature is enabled, the server will release the record lock if another client requests the lock. But if no other client requests it, I think it might still show up in the locked record count. I’m at WWDC this week and I am simply too tired to check the source code right now to figure that out for sure, but I think it’s likely that it might continue to include “orphan” records in the count, even though they essentially aren’t actually locked.