I'm running an append to a large database and get the message "Not enough space on the temporary disk". The tables reside on an SQL server which has 3gig free on the c drive and 17 gig free on the d drive and the Access append query is being run from my pc which has 3 gig available.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Not enough space on temporary disk
- Thread starter kluca
- Start date
ReluctantDataGuy
Programmer
To make sure its not your PC, check your temp folder in the WINDOWS directory. That is usually the "temp disc" that holds files for application processing.
Its size is controlled in Control Panel / System properties / Advanced / Performance Properties / Settings / Advanced / Virtual Memory / Change
That is... on Windows XP Home
Now, what often happens is that applications crash, leaving files behind in the Temp directory. Or your PC locks up and you have to reboot, or whatever.
To recover lost space on your Windows/Temp directory, simply delete all the files out of it. If any files can't be deleted, its because they are being used currently.
You can also use the System Cleanup application in Start / All Programs / Accessories / System Tools / Disk Cleanup.
It takes a while to calculate where you can save space, but once it comes up, one of the items in the list is "Temporary Files" If it says you can save a lot of space by cleaning up the "Temporary Files" then go for it.
If that doesn't work, then maybe the problem is on the server after all.
Its size is controlled in Control Panel / System properties / Advanced / Performance Properties / Settings / Advanced / Virtual Memory / Change
That is... on Windows XP Home
Now, what often happens is that applications crash, leaving files behind in the Temp directory. Or your PC locks up and you have to reboot, or whatever.
To recover lost space on your Windows/Temp directory, simply delete all the files out of it. If any files can't be deleted, its because they are being used currently.
You can also use the System Cleanup application in Start / All Programs / Accessories / System Tools / Disk Cleanup.
It takes a while to calculate where you can save space, but once it comes up, one of the items in the list is "Temporary Files" If it says you can save a lot of space by cleaning up the "Temporary Files" then go for it.
If that doesn't work, then maybe the problem is on the server after all.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question