Are you running any anti-virus sftware on the server and workstations? Try to turn it off temporary to see if it makes any difference.
>
>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).
>
--sb--