Compression

Hi Simon,

Thank you for your question and welcome to the forum.

You must have the database open in Exclusive mode in order to use the Compact and Close feature in the Access options. So anyone else using the database would have to close it first.

I have put a link below:

http://office.microsoft.com/en-us/access-help/help-prevent-and-correct-database-file-problems-by-using-compact-and-repair-HA010235583.aspx

I hope this answers your question.

Regards

Simon