Compact on Exit (when flagged)

[bpitche]

I know how to make my database compact on exit, but I need to do something a little more complicated. I have a database that I use an import procedure with. The database is strictly used for reporting. I am using a flag that is set to "True" when the import is run. I want to use this flag (when = True) to force the database to compact and repair on exit. Is there any way to do this. I do not want to run the compact everytime the client exits the database as it takes too long to get out of the program.

Thanks in advance!! Brad Pitcher
The Hoover Company
bpitcher@hoover.com

 

[oharab]

have a look at faq705-1955.
It's aimed at Access 97, but it's easily adaptable. Instead of setting a flag, just run this code.

HTH

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------