Hi;

I have a small network of WinXp machines running on a Win2003 server. There is no SQL server. My application resides on a share on the server, and we run it from a shortcut on the desktop. The database and the tables reside on the same share as the application.
Queries take a very long time to complete when running through the network. A query that takes under a second to complete locally, would take 10 seconds to complete through the network.

My question (Finally): Is there a trick to solving this problem without going client-server? I would like to continue using SQL commands, but I may need to create cursor and then seek and populate the cursor manually (This is very fast even through the network).

Thank you all,

Alen.