You probably are having a locking problem. You might need to take a look at the use of transactions to prevent this from happening.

Take look at message "Transactions and Remote Views questions" (Thread ID: 662113) that was posted on 5/28/2002 to see if that helps you out.


>Hello All -
>
>I have a multi-user VFP6 SP5 EXE installed at a client site where the data (DBFs) and the application all reside in a common directory on a server. Each user has a shortcut to the executable on their desktop. During a data-importing process, I enable optimistic table buffering on 4 tables and update the tables with new data. Updates are made to approximately 20-30K records. I then calculate before/after counts and totals for display and allow the user to cancel (TABLEREVERTs) or proceed (TABLEUPDATEs).
>
>When only one user is logged in to the system, the TABLEUPDATEs on the 4 tables occur in about 2-3 minutes. However, when there is more than one user logged in to the system, the performance degrades to about 2 HOURS!
>
>Can anyone offer an explanation as to why the performance with more than one user logged in is so slow? Do you have any suggestions for improving the performance?
>
>Thanks,
>Scott