Results 1 to 4 of 4
  1. #1
    goyal is offline Novice
    Windows XP Access 2000
    Join Date
    May 2009
    Posts
    3

    "Not enough space on temporary disk" error

    Hi,


    I am running a make table query. my access dB size is around 450 Mb. I am always getting the following error:"Not enough space on temporary disk"



    My C drive has like 30GB free. My temp folder reaches 1.95GB when I run this query (before that it is like 50mb). So I am thinking is it because of the Access 2GB limit (Access 2000) or is it because of some size restriction on the temp folder ?

    Someone please help.
    thanks in advance.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How about posting the SQL for the MakeTable query you are running?

  3. #3
    goyal is offline Novice
    Windows XP Access 2000
    Join Date
    May 2009
    Posts
    3
    The query:

    SELECT U402385_DHS_UNFUNDED.ORDER_NUM, Max(DOW_DATA_DW_VP_TRANS!POSTG_DT) AS ATPT_MT_POSTING_DATE, Max(DOW_DATA_DW_VP_TRANS.PLN) AS MaxOfPLN, DOW_DATA_DW_VP_TRANS.AUTH_CODE INTO [04a Post Date]
    FROM U402385_DHS_UNFUNDED INNER JOIN DOW_DATA_DW_VP_TRANS ON (U402385_DHS_UNFUNDED.ACCOUNT_NUM = DOW_DATA_DW_VP_TRANS.ACCT_NBR) AND (U402385_DHS_UNFUNDED.ORDER_NUM = DOW_DATA_DW_VP_TRANS.ORD_NBR)
    WHERE (((DOW_DATA_DW_VP_TRANS.TXN_CD)=1))
    GROUP BY U402385_DHS_UNFUNDED.ORDER_NUM, DOW_DATA_DW_VP_TRANS.AUTH_CODE;

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    How many records do you feel this query should generate?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM
  2. Error "Record is Deleted"
    By koper in forum Access
    Replies: 8
    Last Post: 03-10-2009, 10:20 AM
  3. "Overflow" error message.
    By joeferraro2000 in forum Queries
    Replies: 0
    Last Post: 03-08-2007, 06:36 PM
  4. "Type Mismatch" Error
    By elmousa68 in forum Access
    Replies: 2
    Last Post: 12-05-2006, 08:28 AM
  5. "Count" and "Countif" in Reports
    By JMantei in forum Reports
    Replies: 1
    Last Post: 06-20-2006, 02:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums