Compact on Close query

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

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
 
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
Click to expand...

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.
 
Back
Top