>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.

5-10x slower is the expected ratio when the query is executed the first time.

try

SET LOCK ON

You can implement a distributed database/replied on the clients,
but it is not the simplest thing to do.