mdb filesize doesn't drop but keeps increase

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

John Vinson

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.
 

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

Similar Threads

Insane filesizes in Word 2k/XP 1
drop down delete 2
Table DROP Misfires 3
Creates db1, db2 on "compact on close" 11
Very Simple Question 1
Outgoing email doesn't send and Entourage Continues to keep trying to send 3
paste keeping formatting 0
1) Run query through a table and 2) keep (or throw away) records 3

Top