I have a database that I have been reworking. The system itself is working fine but there are several reports (actually groups of reports) I used Microsoft Query (invoked from within Excel) to create. These reports pull data from Access and load it into a Workbook. There are from 20 to 30 individualy queries in each of the Workbooks. While in Office 97, I was able to select "Refresh All" and after a brief wait, all queries ran and the reports were made current. The problem is that the entire enterprise was recently upgraded to Office 2000 and now, when I try the batch update, the system freezes up for about 10 minutes and then returns an error message "Not enough space on temporary disk." After this error there are several additional errors that indicate particular queries did not run. Then finally, 3 or 4 do run successfully.
The help desk staff has: added ram, installed a second hard drive, increased the size of the paging file (virtual memory), reinstalled Office 2000 several times.
I have run every one of the queries individually and they all work fine. I regenerated all of the queries in one of the reports after the upgrade just to make sure that there were no conversion problems and the result was exactly the same.
Any help resolving this problem would be very much appreciated.
The help desk staff has: added ram, installed a second hard drive, increased the size of the paging file (virtual memory), reinstalled Office 2000 several times.
I have run every one of the queries individually and they all work fine. I regenerated all of the queries in one of the reports after the upgrade just to make sure that there were no conversion problems and the result was exactly the same.
Any help resolving this problem would be very much appreciated.
