Jim,

>Sorry, no, other than possibly heavy traffic (with lots of collisions) on the network.

Good point...how big are the records coming down? If each record is 1K, for example, then 5000 records would be a 5 MB download...could take a bit of time on a slower network.

Can you copy the tables locally and test the query speed? It can be hard to tell if the speed hit is in the query or in the moving of the resulting recordset...

JoeK