autoexec compacting issue

[CarlM1975]

Hi all

I have a database that has an autoexec macro, at the end of the macro some code runs that compacts the database. All works fine apart from once the compact has finished and the db opens up again the autoexec is once again invoked and it gets stuck in a loop.

Is there anyway of stopping the autoexec running again once compacted, or getting the db to immediately shut down on completion of the compact.

Many thanks

Carl.

 

[namliam]

Just go into the options of the database and check the "compact on close" option.

Then just close the DB from your Autoexec macro.

 

[Singh400]

It's not advisable to compact via a macro, just do what mailman said