How to delete records from database to save space?

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hello,

I need to delete unused data from my database, so I can reduce the
MDB file size. How do I do it?

This is my delete command:

delete from events where events.customerid in (select events.customerid
from events, customers, companies where events.customerid =
customers.customerid and customers.companyid = companies.companyid and
companies.inactivate = 'Y');

After I deleted these records, but the MDB file size does not
change on harddisk.

Thanks.
 
You must compact the database after you delete to recover the space.

Look under the Tools menu- probably under the Database Utilities item

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
John said:
You must compact the database after you delete to recover the space.

Look under the Tools menu- probably under the Database Utilities item
Click to expand...

It worked. Thanks, John.

Btw, can I use SQL command to do it? Because I am use C++ to operate
access database.
 
Daniel said:
It worked. Thanks, John.

Btw, can I use SQL command to do it? Because I am use C++ to operate
access database.
Click to expand...
Nvm, I did some search on google, I got my answer. thanks
 
Back
Top