Not Enough Space on Temporary Disk???

  • Thread starter David Fawn via AccessMonster.com
  • Start date
D

David Fawn via AccessMonster.com

Hi,
I tried to run Make Table Query and during processing I've got this
message: "Not enough space on temporary disk" - or something like this,
it's my translation. I assumed it wasn't enough virtual memory, so I set i
to 2000 MB (it was max 774 MB before and my file has about 25 MB), but it
didn't help. Do you know where the problem is?
 
J

John Vinson

Hi,
I tried to run Make Table Query and during processing I've got this
message: "Not enough space on temporary disk" - or something like this,
it's my translation. I assumed it wasn't enough virtual memory, so I set i
to 2000 MB (it was max 774 MB before and my file has about 25 MB), but it
didn't help. Do you know where the problem is?
Click to expand...

I've seen this problem fairly often. Apparently Access tries to
construct the entire new table in memory before writing it, and it
blows out even huge virtual memory spaces.

One solution is to create the target table, empty (this has the
advantage that you can define primary keys, indexes, field sizes,
etc.) and change the MakeTable to an Append query into the new table.

John W. Vinson[MVP]
 
Top