>Hi Mark! thanks for your reply.
>The satatement is a typical select [list of fields] from my table where [conditions].
>The issue is that the same statement run ok in a NT 4.0 machine.
>I whish to know if exist any problem with VFP6 an Win 2000, because I have been used my program over a couple of years in a NT 4.0 network and now I try to upgrade some machines to W2K an those things begin to happen.
>The table that I query have 890.000 records and the query must retrieve over 20000.
>Thanks for your time.
>Pedo Giraudi

I owuld check to see if you have enough space on the disk where your TEMP folder is. This is where the temporary cursor is being created. Make sure your TEMP environment variable points to an existing folder [e.g., C:\WinNT\Temp] and that there is sufficient disk space to accommodate a file of that size.

I do question the need to retrieve that many records except for reporting purposes. Even then, you should be aggregating the data into statistical groups/counts/sums. No user can realistically manage, interpret or need access to that many records at any one time.