ACCESS 2007 database compacting

[Jacob Mathai]

In ACCESS 2003, I was able to compact a live data base (single user) with a command button (using SENDKEYS command). ACCESS 2007 does not use sendkeys. Is there any way to compact an ACCESS 2007 using a command button on the Menu?

 

[Singh400]

Would it not be better to use "Compact on Close" method. Rather than anything else? IMO using SendKeys was a bad idea too.

 

[boblarson]

In ACCESS 2003, I was able to compact a live data base (single user) with a command button (using SENDKEYS command). ACCESS 2007 does not use sendkeys. Is there any way to compact an ACCESS 2007 using a command button on the Menu?

I can use sendkeys in 2007. You do have to have it in a trusted location to do so. Here's the code to do it in 2007:
http://www.btabdevelopment.com/main/CodeSnippets/CompactDatabase/tabid/122/Default.aspx

 

[SAGulick]

Try:

'Repairs and compacts DB
CommandBars("Menu Bar").Controls("Tools").Controls("Database utilities").Controls("Compact and repair database...").accDoDefaultAction

 

[Jacob Mathai]

Thanks to all who responded. I was able to use Bob Larson's solution.