Not enough space on temporary disk. (Error 3183)
in [General]
|
From: arv_eli on 5 Jan 2007 17:10 Not enough space on temporary disk. (Error 3183).....while running a large query, i need to resolve this problem??
From: '69 Camaro on 5 Jan 2007 17:36 Hi. > Not enough space on temporary disk. (Error 3183).....while running a large > query Jet creates a temp database in the temp directory (as defined in in one's environment variables) and places temporary data in it while running the query. If there isn't 2 GB of disk space available or the query needs more than 2 GB to store temporary data, then you'll receive this error message. This is most frequently caused by not using ANSI SQL joins in the query. Check your query first, and if that's not the problem, then look to see if you have enough disk space in your assigned temp directory. If not, make more space available by deleting unnecessary files in the temp directory. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. "arv_eli" <arveli(a)discussions.microsoft.com> wrote in message news:DE77F39F-28F8-463B-A516-8D91550E2334(a)microsoft.com... > Not enough space on temporary disk. (Error 3183).....while running a large > query, i need to resolve this problem??
|
Pages: 1 Prev: Opening Access Forms causes crash. Next: Access Startup Error |