compact the database automatically

[Paul]

Hi,
I developed & deployed a multi-user application, as more
new records was created, I plan to do more Compact to
improve the effiency of the system. I found Access can
automatically Compact database every time you close it (by
tools/options/general and select the Compact on close
check box), so if you're the last user, then the system
will Compact the database. If I applied this method, will
there be any concern? I don't want to mess the system. Or
is there any better way to Compact the database without
interrupt user's daily operation?
Thanks for your kindly advise.

 

[Arvin Meyer]

Hi,
I developed & deployed a multi-user application, as more
new records was created, I plan to do more Compact to
improve the effiency of the system. I found Access can
automatically Compact database every time you close it (by
tools/options/general and select the Compact on close
check box), so if you're the last user, then the system
will Compact the database. If I applied this method, will
there be any concern? I don't want to mess the system. Or
is there any better way to Compact the database without
interrupt user's daily operation?

If your database is split so that the front-end (code, queries, forms,
reports, etc.) are on each workstation, and the data tables are on the
server, as it should be, then compacting on close only compacts the
front-end. This is the way Access compacting on close should work.

You need to manually, or with a custom database and scheduling program, or
with a special product like FMS Total Access Agent:

http://www.fmsinc.com/Products/Agent/index.html

compact the back-end on the server.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access