Not Enough Space On Temporary Disk – Access 2000

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

Viewing 0 reply threads
  • 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

Viewing 0 reply threads
  • You must be logged in to reply to this topic.