Thks John,...
I am using semaphore locking method,.every table I have I create a new field thathat contains a logical field to determine if the record is locked or not...
simply disallow an edit if this field is .T.

I know it sounds like an amatuer in VFP but it works...Automatic locking in VFP is crappy and can't depend on the Network to handle so many transactions/locking etc..

it seems that this was recommended in the book titled "Using VFP 5.0" published by QUE, ...author Michael Antonovich ..page 705

Rgds,
Jeff

>I have long sought after an event that fires when lock is attempted. Simply put, having VFP automatically control your pessimistic locks has many problems. If you must have pessimistic locking, set the buffer mode override to Optimistic. Then, in code, create a class that manually handles the Rlock()'s - just like we did in Fox 2.x.
>
>I don't use pessimistic locks as they are irrelevant in Client/Server scenarios.
>
>< JVP >
>
>
>
>>I have design a form and have compile and run it as an exe file...
>>This form is set to bufferOverride to Pessismistic Row Buffering
>>
>>This is the problem....at the design stage if two datasessions are trying to access the same rdecod an error msg will be displayed sying the record is in use by another user....then retuns me back to the form...
>>
>>But if I run is as an executable....the same messsage appears if someone is editing the same record,..after that the program just terminates instead of returining to the form. How do I trap this error message and return to the form instead?
>>
>>Can anyone help?
>>
>>Thanks
>>
>>Jeff