Compacting database, through VBA, while running module? 1

[xtreme1]

Is it possible to compact a database while it is open? I've tried the CompactDatabase method, as well as DoCmd.RunCommand acCmdCompactDatabase. I feel like there must be some way for me to automate this from a single module, instead of having one that runs a program and a seperate one that handles the compacting. That just seems inefficient to me. Anyway, I appreciate any thoughts or ideas...thanks in advance.

xtreme1
rbio@excite.com

 

[PaulF]

assuming you are using Full Menus, you can use SendKeys. Create a Macro with SendKeys as the action and use

%(tdc)

for the KeyStrokes and

No

for Wait


This opens the Tools Menu, selects Database Utilities and then Compact Database.
PaulF

 

[xtreme1]

Gracias Paul, was very helpful. =]

xtreme1
rbio@excite.com