DB getting massive and I don't know why!!

[DavidMark]

Hi guys,
I have a DB(97) that is on a contstant loop, updating every 1.5 minutes approx. Two tables have their contents deleted and refiled with about 1000 records, from a .txt import. Iv'e checked the tables and nothing is accumulating anywhere. After a few days the DB crashes because it is getting so big. Does anyone know why the DB is getting so large?

Thanks in advance

Dave

 

[JimHorton]

Dave,
This is normal, you need to compact regularly. Access treats records like DOS treats files--deleted is not *really* deleted, the record is just made not available. Worse, the space isn't reused as it is in DOS.
--Jim