Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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, [list].Month)
    ORDER BY Month.Month
    WITH OWNERACCESS OPTION;

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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?
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •