I have an Access 2000 database which I use to track dates of various sporting events. As each weekend passes, I edit the database and remove all of the “old” entries. The database never has more than 90 to 100 records at any given time, however, over time the overall size of the database continues to grow, even though it always has the same relative number of records.
In other words, I started out with a database which was about 970K in size. Throughout the year, as I add new events and remove old events, the total number of records (events) in the data base has remained approximately the same, but the size of the database keeps growing!
It is now about 1.5 MB in size! How can I make it so that the overall size of the database is only as large as the number of current records in the database?
Thanks for any help…
Bart Snell
Oregon Disc Sports
