Brad,
>I have three pc's connected through Windows 98, sharing one of the drives. I use an SQL SELECT
>to build a temporary file of a customers bills. Then the operator selects one to review. The Master File has
>50,000 records in it. This process is very fast if the operator is working on the server (about a second).
>If the operator is on one of the other pc's the same process takes about 10 seconds. What can I do to
>speed this up?
Which process takes about 10 seconds? The SQL SELECT, the operator selecting one to review, or retrieving the selected item?
If the SQL SELECT, please post the SELECT statement for us to see, and tell us what your index tags are for that table.