>Kevin,
>
>>Great idea, I've given that a go by placing 7 different folders on my local server.
>
>I wonder if the PRG would give a different result if you did not have the USE statements, but instead included the path/filename (nameexpression) directly in the SQL (or SET PATH differently before the query for each office).
>
>When you said the SQL in the C# app was identical, did you mean that you were also issuing the same USE statements through the OLE-DB driver, or did the SQL statements in the C# app actually include the path/filename (or a SET PATH) for each iteration of the seven offices?

The OLE DB driver was setup on that particular path, so you are right in that it opens the tables automatically.

I tried your suggestion using the SET PATH and it was actually slower in VFP....

Kev