Hello
I have finally completed an application and am preparing to install it
on a network of 10 users.
The application will be split FE/BE. The application has its own
login, which controls the
users ability to either ViewOnly or FullRights. Using Access2K. 20MB
Database.
My questions pertain to CompactOnClose:
1- How often?
2- For lack of a better option, I have choosen the option
Tools->Options->CompactOnClose as Checked. Is this an acceptable
practice for Compact & Repair, since it seems that every
time a user closes (ie EACH-DAY/EACH-USER) the CompactOnClose fires
regardless of
the user having made changes or not. Is this too often, will this cause
more harm than good ?
3- Does the CompactOnClose affect the FE for each user and the shared
BE ?
4- When fired, does a Compact & Repair take place or Is it a Compact
all the time and a Repair only if needed ?
5- How do the pros typically manage Compact & Repair ???
ThankYou
Greg