not enough space on temporary disk

S

srs

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

Michel Walsh

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
 
Top