mdb filesize doesn't drop but keeps increase

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Hi,

Appreciate if soneone can help me here.
Thanks a bunches !

I have huge table of >133,000 records and with >25 Fields. The filesize
is 49 Mbytes.

However the .mdb filesize remains the same even after I have deleted
130,000 records. I have many such huge mdb files and running out of
harddisk space.

What must I do to let the filesize drops each time I deleted away those
unwanted records ?
 
What must I do to let the filesize drops each time I deleted away those
unwanted records ?
Click to expand...

Tools... Database Utilities... Compact and Repair Database.

Do this often, certainly whenever your database doubles in size. It's
standard routine maintenance.
 
The space is not recovered until you compact your data base (see the
tools menu). It is a good idea to run repair first, from the same menu.

BTW that is only a medium size database ;-) However having 25 fields
and looking at the size, leads me to believe you would be well served to
lean about normalizing databases. It allows you to store a lot of data in a
small space and allows the database to work faster. It means you may have
several tables storing the data you now store in one.
 
Back
Top