>Hello,
>
>PLEASE HELP...........
>
>I'm writing a little system with Access, but the expansion of the file size is scaring me, so I wondering is there any command can compact/shrink the database, instead of doing it from Access menu bar?
>
>Thank you very much
>Aston
Hi Aston,
This is an excerpt from MS Access Help:
MS Access can automatically compact a MS Access database or
MS Access project every time you close it.
Open the Access database or Access project that you want MS Access to
compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact On Close check box.
Note: Compacting does not occur if you close a multiuser (shared) database
while another user has it open.
Another way to mantain your Access database in good shape would be to use special utility from FMS and compact the database during night time. Please see the link below:
http://www.fmsinc.com/products/agent/index.htmlHTH
Igor Gelin
Database Developer