I am running an MS Access update query using ODBC. The updated table has aprox. 6500 records, all of which are being updated in one field. The query runs for a few minutes before dispaying the message “Not enough space on temporary disk”. In my environment variables i have TEMP set in the system variables to the C:\WINNT\TEMP folder and in the user varaibles to c:\Documents and Settings\… .There is aprox. 5.5Gb free on my C: drive.
My Input table coinsists of 116000 records. It is not really convenient to reduce the number of update records any more.
THe SQL is as follows:-
UPDATE CUSTPART INNER JOIN MFGDB_CP_DISC_DATA ON CUSTPART.CP_INST_NBR = MFGDB_CP_DISC_DATA.CP_INST_NBR SET MFGDB_CP_DISC_DATA.CP_DISC_BRK_PT = [CUSTPART]![CP_DISC_BRK_PT_1_], MFGDB_CP_DISC_DATA.CP_DISC_RT = [CUSTPART]![CP_DISC_RT_1_]
WHERE (((CUSTPART.CP_INST_NBR)=1) AND ((CUSTPART.CP_CUST_NBR)=[Enter Account Nbr]) AND ((MFGDB_CP_DISC_DATA.CP_DISC_DATA_INX)=1));
