Not Enough Space on Temporary Disk

[Rich]

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]

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.

 

[Guest]

Wayne,

We've tried everything you listed below but we still get
the same error. There is 25gig of free space on the C:
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

 

[Henro]

What OS, what ServicePack and how big is your total disk?

H.

 

[Guest]

Henro

The OS is WIndows XP Professional service pack 1, C: drive is 36gig total with 25gig free space.

 

[Wayne Morgan]

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?

--
Wayne Morgan
Microsoft Access MVP

Henro,

The OS is WIndows XP Professional service pack 1, C: drive is 36gig total

with 25gig free space.