Error: Not enough space on temoporary disk

[rob parkin]

I have two Access 97 queries which have been running
month-in-month-out for nearly 5 years. We are now having problems
with these - specifically we are getting the "Not enough space on
temporary disk" message.

I think all fields that need to be indexed are indexed. I've upped my
virtual memory, I've changed the location of the Temp folders (to a
drive with 26gb free) and I've increased (in the Registry) the number
of MaxLocksPerFile from 9500 to 100000. Still get the error message!

Strange thing is Query A runs ok on my PC but query B fails with the
"space" problem, but on my Clients PC query A fails and query B runs
ok.

Any ideas because I've exhausted mine ?

 

[JohnFol]

Sounds like the query is taking more than a 2Gb limit.

Perhaps a compact / repair may help, or a rejig of the queries is in order.

 

[david epsom dot com dot au]

drive with 26gb free) and I've increased (in the Registry)

Note that A97 fails when the temp file gets to 2GB.
If your temp file is getting that big, the extra 24GB
won't help any.

I've upped my virtual memory

A97 uses Win 3.1 memory management: that is, it uses
a temp file instead requesting memory.

Do you know if the queries are actually using 2GB of
temp file? What kind of queries are they?

(david)