Compact and repair (2003)

[RhondaStockton]

Hi there
I have a user who built a database that opens with a startup form without showing the db window. The users just close the form and then exit Access. The user wants to put a button on the form that can be clicked to compact and repair the database as well as exit the database.
Any ideas?
Thank you

 

[Joe4]

It is my understanding that it is difficult/complicated to write VBA code to compact & repair the database. However, there is an option that may serve your needs.

Under Tools | Options | General, there is an option to "Compact on Close". If you select this option, the database will automatically be compacted every time it is closed (as long as the person has exclusive right to the DB at that time).

Here is also an article of information:
http://office.microsoft.com/en-us/assistance/HP051874491033.aspx

 

[RhondaStockton]

This is absolutetly stunning, thank you!
And thanks for the extra link!