Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Temp File size too low (Access 2002)

    I am running a rather large query and get the following message:
    Not enough space on temporary disk. (Error 3183)

    An explanation follows:
    You tried to perform an operation that requires more space than is available on the temporary disk. Your temporary disk location is based on the TEMP DOS environment variable, which was set when your system started.

    How can I increase this file size, I have no idea where to look.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Temp File size too low (Access 2002)

    I suspect your problem has to do with the swap space settings on the particular computer your are using. The method for changing that depends on what OS you are using. In general it is located on the System option of the Control Panel, and is often referred to as virtual memory. The explanation is probably a decade old when we were running Access 2.0 on Windows 95 (or even 3.1).
    Wendell

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Temp File size too low (Access 2002)

    From what you have described I have unearthed a dinosaur.

    I have set the option to let Windows determine the Temp File size, it was set as 512Mb to 1024Mb. I'll see if this makes a difference.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Temp File size too low (Access 2002)

    I forgot to check the query, I had inadvertantly set it up as a Cartesian Product query.

    Silly me.

    Thank You Wendell for your support.

Posting Permissions

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