Compact Database via code

Hello All,

I am not sure if this is being posted in the correct group.  I am looking
to 
compact a database via code.  When I try I am told that the compact and 
repair can not be accomplished via code.  Is there some way to run this by

using VBA?

Thanks,

Rob