I'm trying to run a simple query on four linked tables and keep getting the message "Not enough space on temporary disk". Each table has between 52,000 - 55,000 records. The files are in a Citrix environment, and the server on which they are located has plenty of space and memory to handle this project.
I copied the files to my PC and get the same error message. My PC has plenty of free space so I don't think the error has anything to do with lack of space or memory. I compacted the files but that did not solve it. I can open each linked table without a problem. The fields on which I'm joining have been indexed. The data files are confidential so am not able to post them.
Any suggestions on what I should try next would be appreciated.