A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Not enough space on temporary disk" for very large table



 
 
Thread Tools Display Modes
  #1  
Old June 7th, 2008, 01:01 AM posted to microsoft.public.access.tablesdbdesign
Margaret Bartley[_3_]
external usenet poster
 
Posts: 30
Default "Not enough space on temporary disk" for very large table

I have a bit more than 2 million fairly small records in a database that's
311 MBs in size. There is only this one table, a simple totals query, and a
few linked tables in this DB. I compacted and recompiled it just before
trying to add an Atonumber field.

When I try to save the table with that new field, I'm getting a message,
"Not enough space on temporary disk".

I defragged the hard drive yesterday, and I've got 110 GBs left empty on a
148 BG hard drive, and no other programs open.

I suspect this error message is not exactly correct, that there is some
Access memory-management variable or file that is being overloaded. Any
hints or help? Maybe a better newsgroup to post to ?

Many thanks.


  #2  
Old June 8th, 2008, 01:08 AM posted to microsoft.public.access.tablesdbdesign
Chris O'C via AccessMonster.com
external usenet poster
 
Posts: 1,160
Default "Not enough space on temporary disk" for very large table

Make a copy of the table, but with no data. Add the Autonumber field to the
copy. Create an append query to append the records from the original table
to the new table and then run the query. When you're sure you don't need the
original table, delete it and rename the new table with the original table
name. Set up the relationships the same as the original's.

Chris
Microsoft MVP


Margaret Bartley wrote:
I have a bit more than 2 million fairly small records in a database that's
311 MBs in size. There is only this one table, a simple totals query, and a
few linked tables in this DB. I compacted and recompiled it just before
trying to add an Atonumber field.

When I try to save the table with that new field, I'm getting a message,
"Not enough space on temporary disk".

I defragged the hard drive yesterday, and I've got 110 GBs left empty on a
148 BG hard drive, and no other programs open.

I suspect this error message is not exactly correct, that there is some
Access memory-management variable or file that is being overloaded. Any
hints or help? Maybe a better newsgroup to post to ?

Many thanks.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200806/1

  #3  
Old June 8th, 2008, 03:20 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default "Not enough space on temporary disk" for very large table

Everything Chris suggested ... and make a backup copy of your db before you
do it!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Margaret Bartley" wrote in message
...
I have a bit more than 2 million fairly small records in a database that's
311 MBs in size. There is only this one table, a simple totals query, and

a
few linked tables in this DB. I compacted and recompiled it just before
trying to add an Atonumber field.

When I try to save the table with that new field, I'm getting a message,
"Not enough space on temporary disk".

I defragged the hard drive yesterday, and I've got 110 GBs left empty on a
148 BG hard drive, and no other programs open.

I suspect this error message is not exactly correct, that there is some
Access memory-management variable or file that is being overloaded. Any
hints or help? Maybe a better newsgroup to post to ?

Many thanks.



  #4  
Old June 11th, 2008, 08:50 PM posted to microsoft.public.access.tablesdbdesign
Margaret Bartley[_3_]
external usenet poster
 
Posts: 30
Default "Not enough space on temporary disk" for very large table

yep, That's what I did, and it worked.
"Chris O'C via AccessMonster.com" u29189@uwe wrote in message
news:8557608d4456c@uwe...
Make a copy of the table, but with no data. Add the Autonumber field to
the
copy. Create an append query to append the records from the original
table
to the new table and then run the query. When you're sure you don't need
the
original table, delete it and rename the new table with the original table
name. Set up the relationships the same as the original's.

Chris
Microsoft MVP


Margaret Bartley wrote:
I have a bit more than 2 million fairly small records in a database that's
311 MBs in size. There is only this one table, a simple totals query, and
a
few linked tables in this DB. I compacted and recompiled it just before
trying to add an Atonumber field.

When I try to save the table with that new field, I'm getting a message,
"Not enough space on temporary disk".

I defragged the hard drive yesterday, and I've got 110 GBs left empty on a
148 BG hard drive, and no other programs open.

I suspect this error message is not exactly correct, that there is some
Access memory-management variable or file that is being overloaded. Any
hints or help? Maybe a better newsgroup to post to ?

Many thanks.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200806/1



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.