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
 
Back
Top