Compact and Repair on user demand

[lgbatdw]

I need to be able to do a compact and repair on demand. I know it can be done from the tools menu, but I have been asked to have it automated so user can simply click a button. But alas, code cannot be running while compacting. Is there a way to do this or am I barking up the wrong tree?

Linda in MN

 

[sfreeman]

Look here:

http://www.experts-exchange.com/Databases/MS_Access/Q_20599943.html