>Hi,
>
>I've noticed a slow down of a query when two users are accessing the same table on a network drive.
>
>If I start VFP, open the database, then run a query that pulls data from multiple tables, the query runs in about 2 seconds. If I then open one of the tables that the query accesses on another workstation in VFP, the query then takes 10 seconds. If I close the table on the other workstation, the query takes two seconds again.
>
>Any idea what could be causing this? It is happening on my network as well as a client's network where they have Windows Server 2003 running.

Have you checked oplock setting ? Set SharingViolationDelay and SharingViolationTimeout to Zero on the server ?

HTH

thomas