It could be related to your setting for SET TABLEVALIDATE.

You could try the value for checking only on update/write if currently using the default value.

How many users in the peer-to-peer network?... And are they all using the same OS?

good luck


>We have run into a situation with a VFP8 database on a small peer to peer network. When a user tries to save a record, a message "Waiting on Lock" appears and it takes a long time before they can start entering the next record.
>
>We have Table buffering set to pessimistic row buffering. Would it help to change to optimistic row buffering?
>
>Any other suggestions on speeding up data entry would be appreciated.
>
>Thanks in advance.