>>>>My experience is that a lock on arecord will be released during a crash. My supervisor does not believe me. Can you please direct me to literature on the subject so that I have some proof on the subject...
>>>
>>>What kind of crash are you talking about?
>>>
>>>IAC, you can try it. Lock a record manually. From another workstation, try to write to the record. You'll see that it is not working. Pull the plug on the server. Restart the server. Try to write to the record. It should work. Of course, I am expecting you are trying that on a test server. lol
>>
>>I meant any kind of system crash, even the kind where you pull the plug. I always knew it would work that way. But some of the people I work with don't.
>
>Well, the best is to show it to them. :)
>
>IAC, you can try a simplier test. Lock a record manually. Try to modify that record from another workstation. Now, from the workstation that locked, quit Visual FoxPro. From the other workstation, you should now be able to modify.

I don't think this would be an accurate test, because probably, when VFP quits normally it shuts down any tables it has open, and subsequently releases any record locks. A better test would be to turn the computer off or hit the reset button. This wouldn't give fox any chance to clean up before it abandons the table.