How to Compact from VBA

[boblarson]

How can I compact a database from a Visual Basic Module (Access 97) so that it will act just as if I had it open and ran the compact utility. In other words, I want it to compact to it's own file name.

Any help would be appreciated.

Thanks,

Bob Larson

 

[Rich]

SendKeys "%(TDC)", False
HTH

 

[boblarson]

Thanks,

I hadn't thought of that simple fix. But it worked great!

Bob

 

[Peter D]

Here's another option: I've just created a free database that may help you out. It's called Compact A List, and with it you can backup, repair, and compact a list of Access database files.

Here's the link: http://www.peterssoftware.com/cal.htm

Regards,

Peter De Baets
Peter's Software - MS Access tools for developers http://www.peterssoftware.com