How to delete temporary files in EG5.1?

[KellyW1117]

Hello All,

I have a question regarding identifying temporary files in EG 5.1. I am trying to import files from MS access by referencing macros. (E.g Filein=&accessfilepath, tablein=A, tableout=A1, etc.) and am receiving an error message

"CLI cursor fetch error: [Microsoft][ODBC Microsoft Access Driver] The query cannot be completed. Either the size of the

query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the

disk to store the query result."

I noticed one way to reduce my temporary file storage is by deleting temp files in "Work" folder under "View"- "SAS Folders"- "Servers" - "Local" - "Library" - "Work". However, almost all my tables in the process flows are stored as "work.XXX" and need to be used. I'm wondering what are the other ways to increase temp folder limit size? or should I change all my "work.XXX" to some other format? Please let me know. Thank you.

[SASKiwi · Accepted solution]

I appears you are using a local SAS server, that is SAS on your PC with EG. That means your WORK library is most likely on your PC hard drive (confirm by checking Properties on WORK). Check how much free space you have on your hard drive. If there is a lot then that is probably not causing the error. If you don't have much free space then try deleting files you no longer need and any temporary files.