Error: Not enough space on temoporary disk

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: rob parkin (rob.parkin_at_bt.com)
Date: 06/24/04 

Date: 24 Jun 2004 04:02:12 -0700

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 ?

Relevant Pages

  • RE: Argument Error in Union Query
    ... I still dont know why the error message occured, ... because I was opening the query like this: ... I suggest you make copies of the queries and start taking them appart until ... My other queries were working fine, then why i try to run the union query ...
    (microsoft.public.access.queries)
  • Re: PHP + MySQL + Queries that depend on each other?
    ... if echo mysql_error; ... If it fails, it will display the succeeded error. ... Should this procedure be done every time a query is done, or, ... or take down the server between queries. ...
    (comp.lang.php)
  • Functions not working in Access 2007 Queries
    ... Although queries using columns from tables/queries are working fine, ... that use functions fail. ... fails with the following error message: ... in query expression 'nz(,0'. ...
    (microsoft.public.access.queries)
  • Re: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)
  • Re: Inline CrossTab Query
    ... The SQL I used I just copied from the three queries in the Query Design ... >> I am trying to produce a SQL statement to bring together 3 queries ... >> I am getting an error message that says there is an Error in the ...
    (microsoft.public.access.queries)