Not Enough Space On Temporary Disk – Access 2000

IT Support Forum Forums Windows Windows 7 Applications Not Enough Space On Temporary Disk – Access 2000

This topic contains 0 replies, has 1 voice, and was last updated by  Webmaster 4 months ago.

  • Author
    Posts
  • #1914

    Webmaster
    Keymaster

    If you get the following error in Microsoft Access:

    Not enough space on temporary disk.

    This is because the query you are running is dealing with too much data. It’s reaching it’s maximum virtual table size (which is a couple of Gb, I think).

    To fix the space issue, alter the query to deal with smaller chunks of data (turning it into multiple queries), or get a real database :p

You must be logged in to reply to this topic.