Compact another database and save a another name

[GillinghamFC]

I have a database that needs to compact another database and save it as another name.

How can this be done using code or a macro.

I would prefer to avoid SendKeys but these can be used if needed.

 

[TrojanRabbit]

<a href=&quot;

http://www.tek-tips.com/faqs.cfm?spid=705&sfid=1955&CFID=75162633&CFTOKEN=74363689&quot;>FAQ</a>

oharab posted the FAQ answer. In his code, he compacts it with another name, then replace the original with the new one. That can, of course, easily be changed.