Repair and Compact

[tboerner]

I want to Repair and Compact my Access database programmatically.

Anybody got the code handy?

 

[GIA]

I'm not advocating this, but I have used Sendkey for the alt-shortcut menu approach. No need to tell me it's lame, but it's a fallback if you don't get the answer you really need. :-V "Outside of a dog, a book is probably man's best friend; and inside of a dog, it's too dark to read" - G. Marx

 

[tboerner]

A point of clarification:

I'd like to do this with Access 2000. I figured it out with Access 97.

dbEngine.compactdatabase Oldfile, Newfile

Does anyone know how to do this in Access 2000?

 

[GIA]

http://www.trigeminal.com/usenet/usenet023.asp?1033

gives highly informative context on the issue.

Their second item relates to shelling a command, a la the following(which is on one line, in case it looks split)...
C:\program files\Microsoft Office\msaccess.exe" foo.mdb /compact

However I saw no mention there of Pope Bill's own retort, which is a standalone .EXE. ...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q273956

Sorry - the link contains semicolons so you may not be able to click it directly - can anyone get this fixed for Tek-Tips? (I'd think this came up a lot here, since K.B. articles are so vital here.):-0 "Outside of a dog, a book is probably man's best friend; and inside of a dog, it's too dark to read" - G. Marx

 

[tboerner]

Thanks. We did go with this solution.

 

[evalesthy]

In Access 2000 there is an option (go to Tools, then Options) and on the General tab there is a checkbox for "Compact on Close". The help index states that "compacting does not occur if you close a multiuser (shared) database while another user has it open".

 

[GIA]

> "Compact on Close"

That is included in the article I referred to. AAR I wouldn't exactly pooh-pooh it, because that article is Michael Kaplan's (trigeminal is his website), making it fairly definitive

http://www.trigeminal.com

"Outside of a dog, a book is probably man's best friend; and inside of a dog, it's too dark to read" - G. Marx