repair/compact database

[iattlakerod]

I am tired of having to manually [Repair & Compact] my database. I have been trying to figure out how to do this automatically when closing the database, both in a single and multi-user environment. I've tried a few things but haven't been successful. Any Tips?

 

[Mile-O]

Search on this forum for code to compact your database and then call that code with a macro as you close your database.

 

[iattlakerod]

thanks, I think.
I'll look around and see what I come up with. The idea sounds like it'd work but hopefully I'll find the answer within the forum.

 

[RonB]

compact on close option

you have a database Tools\options\General\'compact on close'

select this check box and current database will compact when its closed

 

[Mile-O]

Re: compact on close option

you have a database Tools\options\General\'compact on close'

select this check box and current database will compact when its closed

In a multi-user environment you would have problems, I think, compacting the database if it's currently in use by aother user.