db size question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
Not sure where to post this, here goe

Access 200

I have a Custom DTS Package that does two things to the same table each time it is run..
a) DELETE FROM [MYTABLE
b) Runs a datadump into [MYTABLE] from a text fil

No matter what size text file I dump into this table (and MYTABLE is being cleaned out), my access.mdb file is growing larger and larger

So, if I delete 10000 records and then add 50 records to this table, the *.mdb file gets BIGGER

2 Questions
a) Why is this
b) How can I keep my file size down

Thanks in advance
ben
 
As Rich D wrote. Compact on exit.

The reason your database grows in size is that Access does not reclaim used
space in normal operation. You have to do a compact for that to happen. If
Access tried to reclaim the used space during normal operation, you would see
very slow performance as it rewrote the entire table each time to recover the
unused space.
 
Back
Top