Compact database question

  • Thread starter Thread starter Marco Simone
  • Start date Start date
M

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
 
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
 
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
 
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
Click to expand...

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.
 
Back
Top