| | |
|
|
|
Not Enough Space on Temporary Disk |
|---|
| message from Rich on 17 May 2004 |
I get the error msg "Not Enough Space on Temporary Disk"
when I copy/paste several thousand rows from Excel to
Access or from running some queries which returns several
thousand rows. I never had this problem before but I got
a new pc and this problem has started.
I'm running Access 2000.
Please help!!
Thanks
|
| Wayne Morgan replied to Rich on 17 May 2004 |
Well, since you have a new PC, did you also install the updates for Office
2000 when you installed that on your new PC? If not, then the first thing to
try would be to install Office 2000 SP3, Jet 4 SP 8, and possibly MDAC 2.8.
Also, run Windows Update and see if there are any OS patches that need
installed.
Once this is done, check to see how much space you have on the disk where
your temp directory is. To find where this folder is located, go to
Start|Run and type %temp% then click ok. Explorer will open at the temp
folder. If there is a bunch of junk in this folder and you have shut down
all your programs, delete the items in this folder. Do the same thing for
the %windir%\temp folder. You may not be able to delete everything in these
folders, but you should get down to no more than a handful of files. You may
also be able to delete them by using Start|Programs|Accessories|System
Tools|Disk Cleanup, however, I believe that this uses the time stamp on the
files and won't delete them unless they meet a certain age requirement.
Another thing to check are the permissions on the temp folders and the
folders that the Excel and Access data files are in. If you're working
across a network, also check the share permissions.
|
| anonymous replied to Wayne Morgan on 18 May 2004 |
Wayne,
drive where the temp folder is located. If we copy the
Access database out the our file server, I can get to it
from a different workstation and everything works just
fine. Do you have any other suggestions???
Thanks Richard
updates for Office
then the first thing to
possibly MDAC 2.8.
patches that need
on the disk where
located, go to
open at the temp
you have shut down
the same thing for
everything in these
handful of files. You may
Start|Programs|Accessories|System
the time stamp on the
age requirement.
folders and the
you're working
Disk"
several
got
|
| Henro replied to anonymous on 19 May 2004 |
What OS, what ServicePack and how big is your total disk?
H.
<anonymous@discussions.microsoft.com> schreef in bericht
news:ed0901c43d14$31bb5f60$a301280a@phx.gbl...
|
| =?Utf-8?B?cmljaA==?= replied to Henro on 19 May 2004 |
Henro,
The OS is WIndows XP Professional service pack 1, C: drive is 36gig total with 25gig free space.
|
| Wayne Morgan replied to =?Utf-8?B?cmljaA==?= on 19 May 2004 |
Rich,
From your description, "If we copy the Access database out the our file
server...", it appears that the file is running on the local hard drive. Is
the Excel file also on the local hard drive? What are the NTFS permission on
the directory that each of these files is located in? You will probably need
Change permissions or better. Can this computer access the file ok once the
file has been moved to the server?
|
|
Archived message: Not Enough Space on Temporary Disk (MS Access Error Message)
