Compact and Repair upon closing a database

[steven.butler]

Is it possible to make the database compact and repair itself when it is closed to prevent it becoming too large?

Alternatively, can you create a macro to compact and repair at the click of a button?

Thanks, Steve

 

[Ron_dK]

Go to : Options > General and check the "compact on close " option.


Hth

 

[Rabbie]

Go to : Options > General and check the "compact on close " option.
Hth

Just remember if the database has more than one person using it this will cause an error if someone else is using the DB. You need exclusive access for Compact.