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.