One last point:
What precisely does "abso-freakin-lutely forever" mean?
There is not much point in soliciting help, if your queries currently take 20 seconds and that seems intolerable to you! What sort of improvement are you hoping for?
Houston.

>I'm trying to optimize these queries that someone else wrote because they take abso-freakin-lutely forever when the remote offices are accessing the program. I'm wondering if there is any way that I could make Fox run the sql on the server and just send the resultset across the wire?
>
>Or is that what it already does when they're running the exe off the server?
>
>Thanks.