Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Not enough space on temporary disk.


  • Please log in to reply
10 replies to this topic

#1 TheGreyGuy

TheGreyGuy

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:51 AM

Posted 08 July 2010 - 06:15 PM

MS Access 2003 throws the above error on a query that worked fine last week.
Processes up to 8 - 10%
Network up to 2.5%
RAM up goes up slightly to < 1G of the 4G
Everything looks normal here...

User is Local Admin
OS is XPSP3

Need anything else?

This job would sooo much easier if wasn't for all the users and their problems! :thumbsup:
This job would be sooo much easier if wasn't for all the users and their problems!

BC AdBot (Login to Remove)

 


#2 angstfeardoubt

angstfeardoubt

  • Members
  • 18 posts
  • OFFLINE
  •  
  • Local time:02:51 AM

Posted 09 July 2010 - 12:34 PM

Read this. It might help.

Edited by angstfeardoubt, 09 July 2010 - 12:42 PM.


#3 TheGreyGuy

TheGreyGuy
  • Topic Starter

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:51 AM

Posted 09 July 2010 - 12:37 PM

Update

Virtual Memory was from 2G - 4G. I reset it up to 8G... Same error.

Thoughts?
This job would be sooo much easier if wasn't for all the users and their problems!

#4 MNguyen

MNguyen

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:01:51 PM

Posted 10 July 2010 - 09:45 AM

How big is your database? Once Access databases approach 2G in size, the error will frequently pop-up.

#5 TheGreyGuy

TheGreyGuy
  • Topic Starter

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:51 AM

Posted 13 July 2010 - 11:13 AM

Side Note - 197G of the 232G HD is free and oh-by-the-way... the DB is 1.25G.
This job would be sooo much easier if wasn't for all the users and their problems!

#6 TheGreyGuy

TheGreyGuy
  • Topic Starter

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:51 AM

Posted 13 July 2010 - 12:47 PM

Angst... thanx for the tip! I changed the "locked files" from 9500 to 200,000 and her queries run a lot faster. Didn't solve the "Not enough space" error but if she's happy I'm happy. Any more of those good ideas? :thumbsup:
This job would be sooo much easier if wasn't for all the users and their problems!

#7 MNguyen

MNguyen

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:01:51 PM

Posted 13 July 2010 - 04:20 PM

You can also try compacting and repairing the database. Sometimes that helps reduce the size of the database.

#8 TheGreyGuy

TheGreyGuy
  • Topic Starter

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:51 AM

Posted 14 July 2010 - 11:45 AM

MNguyen - Thanx, we already tried that one. Anymore more good thoughts or ideas?
This job would be sooo much easier if wasn't for all the users and their problems!

#9 MNguyen

MNguyen

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:01:51 PM

Posted 14 July 2010 - 09:40 PM

Is the query you're running an append or make table query?

#10 TheGreyGuy

TheGreyGuy
  • Topic Starter

  • Members
  • 28 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:Tacoma, WA
  • Local time:11:51 AM

Posted 15 July 2010 - 12:29 PM

OK, let's see if I can translate what our Crime Analysis folks are saying...

We are innerjoining Data from our side (Domain1) to a Data Table on their side (Domain2) to do a Make Table query.

Everything works fine on the D2 side and it used to work just fine on our side. BTW, both Access 2K3 or 2K7 give the same error and yes we have tried it (with the same results) on different PC's.
This job would be sooo much easier if wasn't for all the users and their problems!

#11 MNguyen

MNguyen

  • Members
  • 10 posts
  • OFFLINE
  •  
  • Local time:01:51 PM

Posted 16 July 2010 - 01:32 PM

Hmmm. The only thing I can think of, is that you might be writing too many records at once. Try running the query in datasheet view and see how many records it returns compared to previous times.




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users