Global Default Options

  • Thread starter Thread starter MikeV06
  • Start date Start date
M

MikeV06

Compact on close has to be set by database. I have a bunch of databases for
which I would like that to be the default as well as new databases. As of
now I open the database, set the option, close the database. I am not
comfortable compacting using tools, compact since it does not remember the
name I am compacting and I want to move it to a new folder with the same
name. It is a pain trying to remember the original name and type it.

Thanks.

Mike
 
Mike,
if these databases are split, it is only the backend that needs compacting
usually.
There have been some reports of compact on close being a cause of corruption
or errors in split databases in a multi-user situation.
If your databases have not been split and are just single-user, compact on
close will probably work OK.
I have seen some code or an add-in that allows you to compact a database by
right clicking it in the explorer window.
Sorry I don't have the details at hand. You could do a search on that.

Jeanette Cunningham
 
Quite simply, you should never compact without backing up you db first, for
the reasons Jeanette gave. The reports I've seen, here and on the other five
forums I visit daily, suggest that this problem is not limited to split/multi-
user databases.
Click to expand...

Uhm, thank you both for the warning. I will be a bit more careful about
compact. Are there any characteristics of the databases that get corrupted
that are consistent so that one can be particularly watchful for that
situation?

Thanks.

Mike
 
Back
Top