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
|
|||
|
|||
Access DB File size don't size down...
Here is the scenario, My Access DB File grew upto 500MB. I opened the file and deleted the table which contained most of these data. After the delete I noticed the file size did not change, it's still 500MB. I want the size to become small again, is there other way beside exporting the remaining tables to a new file? |
#2
|
|||
|
|||
NIL,
One of Access's shortcomings is that it does not automatically release unused space when you delete data or objects. To do that you need to manually Compact the database (Tools Database Utilities Compact and Repair Database in A2K). This will not only release unused space, but also reindex it, so it helps maintain performance. Therefore you have two good reasons to do that regularly. If you are on Access 2K or later and your database is monolithic (i.e. not split), you can check the Compact on Close option (Tools Options, General tab) so it will be automatically compacted every time you close it. This will also work nicely on the FE of a split database, although it is generally less critical there, while for the back end a more sophisticated method would be required to auto compact it, say, overnight, when not in use (unless you want to do it manually). HTH, Nikos "NIL" wrote in message ... Here is the scenario, My Access DB File grew upto 500MB. I opened the file and deleted the table which contained most of these data. After the delete I noticed the file size did not change, it's still 500MB. I want the size to become small again, is there other way beside exporting the remaining tables to a new file? |
#3
|
|||
|
|||
it worked! thanks Nikos! "Nikos Yannacopoulos" wrote: NIL, One of Access's shortcomings is that it does not automatically release unused space when you delete data or objects. To do that you need to manually Compact the database (Tools Database Utilities Compact and Repair Database in A2K). This will not only release unused space, but also reindex it, so it helps maintain performance. Therefore you have two good reasons to do that regularly. If you are on Access 2K or later and your database is monolithic (i.e. not split), you can check the Compact on Close option (Tools Options, General tab) so it will be automatically compacted every time you close it. This will also work nicely on the FE of a split database, although it is generally less critical there, while for the back end a more sophisticated method would be required to auto compact it, say, overnight, when not in use (unless you want to do it manually). HTH, Nikos "NIL" wrote in message ... Here is the scenario, My Access DB File grew upto 500MB. I opened the file and deleted the table which contained most of these data. After the delete I noticed the file size did not change, it's still 500MB. I want the size to become small again, is there other way beside exporting the remaining tables to a new file? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Jet35.sp3 | doglover | Database Design | 3 | August 26th, 2004 04:41 PM |
Question on lauching access and syntax error during batch file | Adam Raff | General Discussion | 2 | August 12th, 2004 04:20 AM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |