Compact Database??????????

[chadt]

Can anyone tell me how to run the Compact Database tool from my VBA code. I current do docmd.RunCommand(acCmdCompactDatabase) but it pops up a window wanting to know which database I want to compact. Is there a way to automate this within the current DB so there has to no user input.
Thanks
Chad

 

[Richie]

Which version of access?

 

[chadt]

Access 97

 

[Richie]

Add SendKeys "%(TDC)", False to a command button.

 

[chadt]

Thanks Richie,
That worked great. One more question, is there a prettier way of doing this?? Like maybe keeping a Form Loaded or something while it compacts.
Thanks
Chad

 

[Richie]

I haven't found a way yet, not sure if there is.