So, when you say "WORKGROUP" in caps is that to firmly tell us that it is a peer-to-peer network arrangement?
If so then what is the OS of the system that houses the data? **IF** it is Win2K then have a look at the UT Bug List #26. It dewcribes a different symptom but sounds like it could be related.

good luck


>All:
>
>VFP 7.0 sp1
>Network is a WORKGROUP with a mixture of XP and 2000 Pro.
>
>I have SET REPROCESS TO 5 and using private data sessions. All of my tables are all contained in a DBC with pessimistic table buffering (4) set ON. The net effect will be VFP will automatically perform a lock on the record when a user begins editing a field on the form.
>
>In my Error event of the text box I'm capturing error 108--"Record is in use by another user". Within the Error event, I'm displaying a custom message that tells the user that another user has this record locked...(blah)(blah)(blah).
>
>All of this is working ok. But a strange thing happens in the Error event--all of the other locks that the VFP/user has placed are unlocked. I'm not doing anything else in the Error event except displaying this custom message.
>
>Does anyone know why all record locks are getting released in the Error evert?
>
>Thanks!
>
>--Paul