General discussion

Locked

Access Dbase size question

By Bart Snell ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Collapse -

Access Dbase size question

by SyscoKid In reply to Access Dbase size questio ...

You need to compact the database to recover space. In Access 97, it's Tools-> Database Utilities-> Compact Database. It should be similar in Access 2000.

Collapse -

Access Dbase size question

by Bart Snell In reply to Access Dbase size questio ...

Thanks! That did it, alright!

Collapse -

Access Dbase size question

by Bart Snell In reply to Access Dbase size questio ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums