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

G

Guest

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?
 
N

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
 
G

Guest

it worked! thanks Nikos!

Nikos Yannacopoulos said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top