Compact database question

[Marco Simone]

I am making database and just notice that file mdb is over 34 megabyte. Then
I tried Compacting database and now is 457 kilobyte. How often is good to
compact database?

Thanks, Marco

 

[Jim/Chris]

How much the database bloats is relates to how many
forms/reports/tables you create/save/delete. If you don't
want to keep checking go to the tools/options general tab
and check Compact on Close

Jim

 

[Ed Robichaud]

All depends. Compacting once per week is normally OK for most users. You
can set the database options to "compact on close", meaning that it will
remove temporary and deleted objects every time the database is closed.
-Ed

 

[John Vinson]

I am making database and just notice that file mdb is over 34 megabyte. Then
I tried Compacting database and now is 457 kilobyte. How often is good to
compact database?

Thanks, Marco

More frequently when you're actively developing than when it's in
production, but regularly in either case. As a rule of thumb, if the
database has doubled in size it probably needs compaction.

When I'm actively working on a database I'll compact daily or even
more often; in production I recommend that users compact weekly or
monthly, depending on the level of usage and the observed speed of
bloat.