Kevin,
>>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....
What about eliminating the USE statements by using (nameexpression) directly in the SQL (the other part of my suggestions in the first paragraph above)? Did you ever get a chance to check that approach?