Re: ERROR: Not enough space on temporary disk. WHY not?
- From: Tcs <TSmithATEastPointCityDOTorg>
- Date: Wed, 15 Mar 2006 08:52:43 -0500
On Tue, 14 Mar 2006 13:58:30 -0800, Jerry Whittle
<JerryWhittle@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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.
.
- References:
- Prev by Date: Re: Concatenating fields from multiple records
- Next by Date: Re: ERROR: Not enough space on temporary disk. WHY not?
- Previous by thread: Re: ERROR: Not enough space on temporary disk. WHY not?
- Next by thread: Operation must use an updateable query
- Index(es):
Relevant Pages
|
