Not Enough Space on Temporary Disk???

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

 

[David Fawn via AccessMonster.com]

I forgot I have about 17 GB free on my hd.

 

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

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]