Access DB File size don't size down...

[NIL]

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?

 

[Nikos Yannacopoulos]

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]

it worked! thanks Nikos!

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