Compacting Design Question

[scott04]

I am using the following code in the on close event of my form:
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction

End Sub
I have heard that you should use the compacting event from a command button.
Can someone give me the reasons that you should only do this on command
rather than every time the form closes? Thanks for your feedback.

 

[Douglas J. Steele]

Why would you want to compact that frequently?

 

[Rick Brandt]

Why would you want to compact that frequently?

Indeed. Frequent compacting is not only unnecessary it can actually cause
problems.

 

[scott04]

I don't want to compact that frequently but I am basically desinging this DB
and then handling it off to someone else. I didnt really want to include a
compact button on a form if i didnt have to because then I would have to
explain it to the end users...

 

[Douglas J. Steele]

I think you should use a button and explain it (or, better yet in my
opinion, provide a shortcut that they can use to compact the database on a
regular basis).

As Rick implies, uncontrolled compacting can be an issue.

 

[scott04]

Thanks for your feedback Doug and Rick

I think you should use a button and explain it (or, better yet in my
opinion, provide a shortcut that they can use to compact the database on a
regular basis).

As Rick implies, uncontrolled compacting can be an issue.