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
|
|||
|
|||
Minor changes result in much larger file size
To modify and further develop my database safely, I first copied it to
another folder. After making various minor changes and general cleaning up, the 14.2 mb file has grown to 20.9 mb. The number of records has not changed. What could possibly account for this gross increase in file size? |
#2
|
|||
|
|||
Minor changes result in much larger file size
On Thu, 6 Nov 2008 13:51:02 -0800, oldblindpew
wrote: To modify and further develop my database safely, I first copied it to another folder. After making various minor changes and general cleaning up, the 14.2 mb file has grown to 20.9 mb. The number of records has not changed. What could possibly account for this gross increase in file size? When you change an object such as a Form or Report, Access makes the changes in a new copy of the object and leaves the old one around (although not accessible, usable or recoverable, generally). You can recover the space that it formerly occupied by using Tools... Database Utilities... Compact and Repair (it's under the Office medallion button in 2007). -- John W. Vinson [MVP] |
#3
|
|||
|
|||
Minor changes result in much larger file size
Thanks! I find it under Office Button/Manage/Compact and Repair...
"John W. Vinson" wrote: On Thu, 6 Nov 2008 13:51:02 -0800, oldblindpew wrote: To modify and further develop my database safely, I first copied it to another folder. After making various minor changes and general cleaning up, the 14.2 mb file has grown to 20.9 mb. The number of records has not changed. What could possibly account for this gross increase in file size? When you change an object such as a Form or Report, Access makes the changes in a new copy of the object and leaves the old one around (although not accessible, usable or recoverable, generally). You can recover the space that it formerly occupied by using Tools... Database Utilities... Compact and Repair (it's under the Office medallion button in 2007). -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Minor changes result in much larger file size
WOW!! It shrank down to 2.6mb from 20!
"oldblindpew" wrote: Thanks! I find it under Office Button/Manage/Compact and Repair... "John W. Vinson" wrote: On Thu, 6 Nov 2008 13:51:02 -0800, oldblindpew wrote: To modify and further develop my database safely, I first copied it to another folder. After making various minor changes and general cleaning up, the 14.2 mb file has grown to 20.9 mb. The number of records has not changed. What could possibly account for this gross increase in file size? When you change an object such as a Form or Report, Access makes the changes in a new copy of the object and leaves the old one around (although not accessible, usable or recoverable, generally). You can recover the space that it formerly occupied by using Tools... Database Utilities... Compact and Repair (it's under the Office medallion button in 2007). -- John W. Vinson [MVP] |
#5
|
|||
|
|||
Minor changes result in much larger file size
On Fri, 7 Nov 2008 08:48:02 -0800, oldblindpew
wrote: WOW!! It shrank down to 2.6mb from 20! g Yep. Access is a good database but it's a very poor housekeeper - must be an old bachelor. Compacting also recompiles your queries, reorganizes indexes, repairs some types of database corruption... it's a good idea to do it whenever the database has doubled in size or on a schedule. HOWEVER it can (rarely) corrupt or even destroy a database; good backups are essential. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|