ERROR: Not enough space on temporary disk. WHY not?

[Tcs]

I'm trying to run a query, but getting this error:

"Not enough space on temporary disk."

I don't understand why. I have 5+ gigs on my C: drive, and 18+ gigs on my D:
drive. I've looked this up in help, and found that this refers to my "TEMP"
variable in DOS. Mine is on my C: drive, currently using just over 2 gigs
(2,097,152 KB), and leaving me the 5+ gigs still available. So what's the
problem? I do know that the .mdb limit is (or at least *was*) 2gb. But this is
a "temp" file, not an mdb.

What am I missing?

Thanks in advance,

Tom

 

[Klatuu]

Your query is likely constructed incorrectly. Depending on how you have your
Joins defined, you can easily chew up a large drive because it is busy
creating a bizzillion rows to try to meet the requirements of the query. I
would suggest you reevalute the query.

I recently did such a thing, but not nearly as magnificantly as you. I was
expecting qbout 5800 rows and created 38,000

 

[Klatuu]

I meant 380,000, sorry

 

[Jerry Whittle]

As I said in an earlier reply on a similar subject, looks like the tables are
properly joined as seen below so that there isn't an outright Cartisian
product. However you really don't know if there are multiple joins between
the fields unless one side is the primary key. You might have a mini
cartisian product happening.

tblAnnRptFY05a_EL LEFT JOIN tblCXLIB_UT420AP ON
(tblAnnRptFY05a_EL.[Cust ID] = tblCXLIB_UT420AP.UTCSID) AND
(tblAnnRptFY05a_EL.[Loc ID] = tblCXLIB_UT420AP.UTLCID);

Next you are doing a DISTINCT which will take a lot of temporary space to
weed out any duplicate records. It might be best to first create a make table
query without the DISTINCT then insert the records from there.

Lastly I don't know if a DB2 db on an AS/400 supports it, but a Pass-through
query would be a lot better if possible. Instead of bringing all the data
into Access, let the DB2 database do most of the work for you. In the case of
other databases, like SQL Server, pass-thru queries are much more efficient.

 

[Gary Walter]

"Tcs"wrote

I'm trying to run a query, but getting this error:

"Not enough space on temporary disk."

I don't understand why. I have 5+ gigs on my C: drive, and 18+ gigs on my
D:
drive. I've looked this up in help, and found that this refers to my
"TEMP"
variable in DOS. Mine is on my C: drive, currently using just over 2 gigs
(2,097,152 KB), and leaving me the 5+ gigs still available. So what's the
problem? I do know that the .mdb limit is (or at least *was*) 2gb. But
this is
a "temp" file, not an mdb.

Hi Tom

I might also try cleaning out your "Temp"
folder. If you are using Win XP or 2K:

in a bat file (or at Command Prompt)

c:
cd "C:\Documents and Settings\Tomxxx\Local Settings\Temp"
del /q /s /f *.*
exit


:: Change "Tomxx" to your user name.
:: To be "safer," use "del /p /s /f *.*"
:: which will ask you about every file

/////////////////////////
or just run

cleanmgr

Worth a shot,

gary

 

[Tcs]

As I said in an earlier reply on a similar subject, looks like the tables are
properly joined as seen below so that there isn't an outright Cartisian
product. However you really don't know if there are multiple joins between
the fields unless one side is the primary key. You might have a mini
cartisian product happening.

tblAnnRptFY05a_EL LEFT JOIN tblCXLIB_UT420AP ON
(tblAnnRptFY05a_EL.[Cust ID] = tblCXLIB_UT420AP.UTCSID) AND
(tblAnnRptFY05a_EL.[Loc ID] = tblCXLIB_UT420AP.UTLCID);

Next you are doing a DISTINCT which will take a lot of temporary space to
weed out any duplicate records. It might be best to first create a make table
query without the DISTINCT then insert the records from there.

Lastly I don't know if a DB2 db on an AS/400 supports it, but a Pass-through
query would be a lot better if possible. Instead of bringing all the data
into Access, let the DB2 database do most of the work for you. In the case of
other databases, like SQL Server, pass-thru queries are much more efficient.

It does, I have, but i have specific accounts for which I'm trying to pull
trans. Seems the last time I tried in this situation, the PT query won't work.

BTW - since my original post, I tried to split my request up to get just one
month, instead of all 12. Same results.

Thanks.

 

[Tcs]

I'm running XP sp2, and Exlporer says:

Size: 436 MB (457,669,597 bytes)
Size on disk: 441 MB (462,766,080 bytes)

Contains: 2,361 files 160 Folders

I can *do* this? I ask because it seems to me a long, long time ago [in a
computer room far, far away] I tried to do this. (NT4 maybe?) And shot myself
in the foot. So I've never tried again.

 

[Gary Walter]

Hi Tom,

If you are worried, then try cleanmgr first:

shut down all your programs
click on Start button
click on Run...
type in
cleanmgr
tell it which drive (if you have more than 1)
when dialog box comes up
click only check box for
Temporary Files
which will delete temp files
"that have not been modified
in over a week"
when you click on OK button.
Of course this won't include
files that are in use...

good luck,

gary

I'm running XP sp2, and Exlporer says:

Size: 436 MB (457,669,597 bytes)
Size on disk: 441 MB (462,766,080 bytes)

Contains: 2,361 files 160 Folders

I can *do* this? I ask because it seems to me a long, long time ago [in a
computer room far, far away] I tried to do this. (NT4 maybe?) And shot
myself
in the foot. So I've never tried again.

"Tcs"wrote
Hi Tom

I might also try cleaning out your "Temp"
folder. If you are using Win XP or 2K:

in a bat file (or at Command Prompt)

c:
cd "C:\Documents and Settings\Tomxxx\Local Settings\Temp"
del /q /s /f *.*
exit


:: Change "Tomxx" to your user name.
:: To be "safer," use "del /p /s /f *.*"
:: which will ask you about every file

/////////////////////////
or just run

cleanmgr

Worth a shot,

gary