Compact on Close option

  • Thread starter Thread starter Ricki
  • Start date Start date
R

Ricki

Can someone tell me if it's a good idea to select the
Compact on Close checkbox on the General tab of the Options
Menu? Can it cause any problems?
 
Ricki said:
Can someone tell me if it's a good idea to select the
Compact on Close checkbox on the General tab of the Options
Menu? Can it cause any problems?
Click to expand...

This only compacts the front-end. What usually needs frequent compacting is
the data on the server back-end.

No, it won't cause problems as long as you wait for it to finish before
turning of the machine.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
It is a bad idea if you have stored the database
in a network share (in "my Documents' if you are
using roaming profiles). You can loose the file
if you run out of network space: you can corrupt
the file if you have network problems, and it will
be really slow anyway - so slow that you may loose
or corrupt the file by turning off your PC during
compaction. Compact on close can be useful if you
have a lot of transient data, causing bloating
of the database, and you have a separate backup
of the database anyway.

If you have a local database (with backups of course!)
then you may just try it and see if you like it.

(david)
 
Back
Top