Compacting a Database

[Jeremy]

Is there anyway to have a database automatically compact
itself? I have databases that act as a status monitor for
our shop floor system. The db's themselves are only about
400k, but within a day, they grow to over 30MB in size
each. I have to open and close them in order to get them
to compact. It's not that big of a deal, but having it
automated would be fantastic. : )

If anyone has any suggestions, I will be patiently
awaiting a reply!

Thanks!

Jeremy

 

[Bogdan Zamfir]

Hi,

Check menu Tools -> Options, General TAB, Compact on Close

HTH,
Bogdan

______________________________
Freelance programmer

 

[GVaught]

Word of caution on Bogdan suggestion. You run the risk of corrupting the
database beyond repair if someone is still in the database. This feature
should only be used if you are the only user of the database.