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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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
|
|||
|
|||
"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 | |
|
|