Error(Not Enough Space on Temporary Disk)

[Ray Harrod]

I am using an IBM pentium 4. I have a large database. One
report uses 6 queries. I keep getting the Not Enough
Space on Temporary Disk error message. Any Suggestions?

 

[Allen Browne]

Is the disk nearly full?
Does it help to delete some files and make several hundred megabytes
available?

Open a command prompt, and enter
SET
Where does the TEMP or TMP environment variable point?
Does that folder actually exist on that disk?

Have you locked the virual memory size for your version of Windows instead
of allowing Windows to assign space dynamically?

 

[Ray Harrod]

The answer was no to all of these. My query was too big
because of multiple matched data.