Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

"Record is locked- retry -cancel" error message

Last updated: 9 Jan 1998

Sometimes a shared Approach database repeatedly returns a "record is locked- retry -cancel" error message, even though the database has been set to optimistic record locking.

This can occur when the link to the network drive where the data and view files are held is down. In this situation you need to exit Approach, reestablish the link to the network drive (usually by rebooting your workstation), and reopening the database in Approach.

It will also occur if a user does a search that causes a new index to be created. Everyone else will receive a "locked" message until the indexing is completed. And, of course, if you have a lot of users and they often attempt to work on the same records then they are going to frequently get record locking errors.

It can also occur for a variety of other more obscure reasons. Some things that have been suggested to keep these at bay are:

        10:00:00 User A locks a record
        10:00:01 User B locks another record
        9:59:59 User C (whose time is not synchronized) tries to access User A's record, which is not yet locked because it isn't 10:00:00 yet. Ooops.

Get the network administrator to set up the network to synchronize the PCs clocks.

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.