Not enough space on temporary disk.

[Guest]

I am receiving this error when running the following query:

UPDATE [T1001 Claims] INNER JOIN CLMPRDFIL_RCPDTP ON ([T1001 Claims].DQOINB
= CLMPRDFIL_RCPDTP.E0OINB) AND ([T1001 Claims].DQP2NB =
CLMPRDFIL_RCPDTP.E0P2NB) SET [T1001 Claims].[Claim Cost] =
([E0ERPR]+[E0ESPR]);


It occurs within 10 minutes of starting. T1001 Claims table has 24,587
records. CLMPRDFIL_RCPDTP has 32,904,317. I am linked to CLMPRDFIL_RCPDTP
thru an ODBC driver. My temp file is located on my C: drive which has 95.2 GB
of free space.

I am stumped and hope to find a better way to build this query.

Thank you in advance.

 

[Michel Walsh]

With Jet? there is still a limit of 2Gig for the database, and that limits
is also implied for the intermediate temporary database it creates to solve
a query. I suggest to define a stored proc on the server, that does the
update, and to call the procedure, not the query itself, so that all the
real work will be done at the server.


Hoping it may help,
Vanderghast, Access MVP