Not Enough Space on Temporary Disk

[Sandi]

Hello All,

I am using Access 97 and was running a Make Table Query. I
kept getting this error when my Jet temp file was being
created in c:\temp, "Not Enough Space on Temporary Disk".
My temp file was reaching 1.2 GB and my c:\ drive did not
have enough room to accomodate the file. I found how to
change my environment settings so that my Jet temp file
could be built on d:\temp (which has 56 GB free). But, am
still getting the message. I then found an article about
changing the "Use Transactions" property on the query.
Which I did. I also changed the query from a Make Table
query to an Append query (this had also been suggested by
someone in the newsgroup). None of this has helped. I am
still getting the error, even though there is plenty of
room on the disk for the file. Does anyone have any idea
why this is happening? Is it because the file is over a
Gig in size and Access can't really handle that? I've had
Access databases larger than this in the past, but this
one is just not working. I am really getting desperate!
If anyone has ANY ideas, suggestions, etc., I would be
most appreciative!!!

Thanking you in advance for your help!
Sandi

 

[Michel Walsh]

Hi,


Jet 4.0 cannot handle more that 2Gig, even in the temporary file. To reach
that point, you probably have a cartesian join, which may be useless:

....
FROM table1, table2
WHERE ... table1.something = table.somethingElse

Try, instead:

....
FROM table1 INNER JOIN table2
ON table1.something = table.somethingElse
WHERE ...


Hoping it may help,
Vanderghast, Access MVP