Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100

    Unanswered: Not enough space on temporary disk

    I'm getting this error when I run a "create new table" query.
    Not enough space on temporary disk
    I just purchased a new machine with plenty of horsepower, space, etc. How can I fix this? Is there a way to best optomize Windows/Access for Windows/Access? Thanks.
    BillS

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    seems bizarre!
    maybe you need to show us the SQL

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100
    Code:
    SELECT TaxRoll.Lease AS Expr1, TaxRoll.RRC AS Expr2, OLS.RRC AS Expr3, Sum(TaxRoll.DIP) AS SumOfDIP, Sum(TaxRoll.Value) AS SumOfVALUE INTO TPF
    FROM OLS, TaxRoll
    GROUP BY TaxRoll.Lease, TaxRoll.RRC, OLS.RRC
    ORDER BY TaxRoll.Lease, Sum(TaxRoll.DIP), Sum(TaxRoll.Value);
    BillS

  4. #4
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    if you just delete the
    INTO TPF
    part of it all.
    does it do what you want?

    you currently have a cross join
    each of n records in TaxRoll 'match' with each of m records in OLS to generate a record in the query return. n*m records ...potentially a huge number of records that might bump into a limit somewhere (db size, datatype size(with your sums) etc). i don't know the details of your db, but personally have never found any use for cross joins.

    is there some relationship between TaxRoll & ORS that could enable a 'meaningful' join?

    izy
    currently using SS 2008R2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •