Compact on Close option

[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?

 

[Arvin Meyer]

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?

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

 

[david epsom dot com dot au]

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)