John

I have a separate database with file name and flag. Evertime a user locks the record, I set the flag to Y. Before opening the file I check the flag. Once a user has finished, the flag is set to N. This also works with exclusive use of files.