Lee said:
Am I right in presuming that setting a database to Compact
on Close is a BAD idea in a multiuser environment?
I can envisage all sorts of problems or am I being too
cautious?
Regards,
Lee
AKAIK Compact on Close only compacts the front-end, which should be
installed separately on each users machine. Unless the front-end uses
temporary tables or otherwise modifies its design during a run,
compacting it does nothing useful. You need a separate schedule to
compact the back-end, at a time when no users are on the database.
--
Regards,
Adrian Jansen adrianjansen at internode dot on dot net
Design Engineer J & K Micro Systems
Microcomputer solutions for industrial control
Note reply address is invalid, convert address above to machine form.
