#22
the reason I would not auto compact is that I tend to C&R after I have made a lot of changes, or when a data file has grown, to a larger size and I want to try to slim it down.
either way I have a rough idea of what it ought to be. So if a 8Mb database is now 25Mb, I might decide to do a C&R.
Now I don't want to try and rescue a trashed database, so I will almost certainly copy it first, just in case the C&R goes wrong, and then I will C&R it manually. All this is why I do not want to auto-run a C&R.
#24
it doesn't happen. I don't share databases. I add code that checks whether the drive letter is bigger than H (say) and is therefore (most likely) a network drive, and shut the dbs down if a user accidentally tries to run the network master copy.