Compact everytime database is opened

[zenenigma]

I have a database I'd like to distribute. The database imports quite a few text files, keeps only certain data from them, and then deletes the excess data. It will be used (likely) daily. I'm using a bulk insert, so only importing the lines of the text files that are useful won't work.


Currently, I'm using sendkeys to compact the database when it's opened (to keep the DB size down). The problem being that when the database is compacted, it does not bring the "startup form" forward afterwards.

Does anyone have a solution to this? I've searched the forums and haven't seen any answers except to have something scheduled on the server (which won't work, as people may not be connected to the server).

Is there a "database exit" event?

-ZE

 

[DougP]

You can compact it on exit then it won't be hoggin up disk space when it's not in use.
Open the "Tools" menu then "Options" and then "General" TAB there is a check box in loower left "Compact on close"
check it.




DougP, MCP