not enough space on temporary disk

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I received this error when I ran a query. How do I increase the space allowed
on the temporary disk?
 
Hi,


If you have more than two Gig of free space on your hard disk, the temporary
result was probably requiring more than the limit of Jet database (even for
temporary database used to store intermediate data, Jet has this limit). Try
to reduce your cross join, applying the WHERE clause before making the join.


instead of:

SELECT ...
FROM x, y
WHERE x.z=alpha



try:

SELECT ...
FROM ( SELECT * FROM x WHERE z=alpha) As w, y

(sure, use the new alias, w, for that virtual table). Note that you can use
a saved query rather than a virtual table.



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Temporary Disk 27
Not enough space on temporary disk. 1
Not enough space on temporary disk 5
Error 3183 4
Run time error:"2147467259 (80004005)"Anyone ever get this error? 1
Not Enough Space on Temporary Disk??? 2
Not enough space on temporary disk - why not? 3
Unusual Error in Append Query 3

Back
Top