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.