I have a 3.5G database containing a table that is 1.5G that will grow quite large. I wish to run some queries off of it in VFP 5 and just return the results.

Although I've programmed in Fox since '84, I'm not very familiar with SQL Server (6.5).

When I try to use a remote view that I created, I get an ODBC error that says my temdb is full (I increased it to 7 MG). If I am not filtering in my remote view, I think I would need to have a tempdb of the equivalent size of the largest table in my database. Is this a correct assumption?

Is there a way around this?

Eventually I will be linking up FoxFire! to this and coding it such. But I would like to just send the query across and receive only the selected records. If I use VFP's GUI SQL creator, I need to load a table or view. If I load the view (containing all the records), I need a HUGE tempdb....help!

there's gotta be an easy way out of this....