Database grew rapidly

[TW]

We are using an identical db at 3 different locations.
The first one has 1030 records and a whopping size of
1.99GB, second has 517 records and 6.77MB size and third
has 1789 records and 6.05MB. The first one went from 4MB
to the 1.99GB in 4 hours of use. The first one was
accessed by multiple users (1-3), stored on a Web server
and the web server pulling information from the db. The
2nd and 3rd were stored locally with one user accessing.
Does anyone have any idea why this grew so fast?

Thanks.

 

[Robert Taylor]

Have you tried compacting the database. I know when you
do a lot of appending and deleting in a table, the space
used up is never returned in Access unless you compact the
database. This database bloating is what I would guess
happened to your database. Compacting should decrease the
size of the database and increase its speed.

Robert