Error 3183 Not enought space on temporary disk (Access 97)

Topic

New Reply

I get the following error message when I run a particular query in Access 97. “Not enough space on temporary disk. (error 3183). The query pulls data from a Client Master inner joined to seven tables related by an ClientID field and a Month table inner joined to a MMYY field in each of the seven tables. I also perform three calculations in this query.
(see SQLcode attached)

Questions:
1 how can I increase the size of the temporary disk refered to in the help menu?
2 is there a better way to optimize this query? I tried to make it two separate queries and still got the same error.

Thanks,
aap2

SQL Code:
SELECT Month.Month, [TPP LIST_AMT].ClassOfBusiness AS [Service Line], [Client Master].[Client No], [Client Master].[Client Name], [TPP LIST_AMT].ListAmount, [TPP LIST_NO].ListNo, [TPP RECALLED_AMT].RecalledAmt, [TPP RETURNED_AMT].ReturnedAmt, [TPP ACTIVE_AMT].ActiveAmt AS Active, [TPP YTD_COLL].YTDCollected, .Month)
ORDER BY Month.Month
WITH OWNERACCESS OPTION;

Reply | Quote

Replies

I found only two articles in TechNet that dealt with this error MSKB articles Q165041 and Q223320. Neither of them are directly related to Access. Are you in fact running Microsoft Repository/Visual Studio 6 without at least SP3 or Microsoft Team Manager 97?

Reply | Quote

Charlotte,
Thanks. I am not running either MS Repository/Visual Studio or MS Team Manager. I did close some of the other applications that were running in the background and ran the query again and it worked.

aap2

Reply | Quote

Then it’s possible that your virtual memory on the machine simply wasn’t set high enough to handle the query plus the other applications at the same time.

Reply | Quote

yes, I believe this was the problem.
thank you.
aap2

Reply | Quote