To illustrate how easy it is to compact a database that someone has open, here are the steps to setup a 123 shortcut and Compact the database.
|Click on Select a File|
|Choose a MDB or ACCDB file|
|Your 123 shortcut looks like this, the people icon displays if database is IN USE|
|Click Compact. If the database is IN USE, Compacting will be attempted again in 10 minutes|
|Once everyone leaves the database, it will be Compacted|
Check out and download 123 here If you can, use Internet Explorer to download the program as its easier.
Office Access MVP since 2006