Database Compact

[Guest]

I have a database with 1 table (6 index & 1 autonumber primary key), the
database size is around 800M with around 600,000 records in the table. I used
compact database option to compact the database after some record removed.
The database size cut down to around 500M. However, the database size is
growing up very fast (almost 10 times faster) when doing new insertion.
(Before the compaction, the database size was growing at around 3M per day,
but now growing at around 30M per day. The number of new records inserted per
day is more less the same)

Any advise?

 

[Arvin Meyer [MVP]]

Set the database to compact on close (Tools ... Options ... on the General
tab) Typically, a database grows faster after the initial compaction. It
never hurts to compact frequently.

I would seriously consider using a database engine that can handle more data
(like SQL-Server) Even at 3 MB per day, you have less than a year of useful
life in your database. Your only other alternative is to build multiple
databases, each with a single table, and link them to a common front-end
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Ken Snell [MVP]]

To add to Arvin's suggestions, another possible reason for such size and
growth might be if the database is storing images. Databases should store
path strings to the image files; store the images on the harddrive.

--

Ken Snell
<MS ACCESS MVP>