Compact and Repair

[VegaLA]

Hi all,
I am assisting a Dept. in enhancing their DB Application in Access 2002 and am reading through their procedure notes for using the mdb and they are instructed to Compact and Repair the MDB everytime they use it.
I remember my old Access Guru years ago telling me that this is not a task that should be done every day, just on a need to do basis if the MDB becomes sluggish/bloated and that its not recommend to do on a daily basis.

Is there a specific reason for not doing this task on a day to day basis, would doing such a thing actually corrupt the MDB ?

 

[boblarson]

I, myself, don't know of anything that would be a problem with compacting daily. In fact I've done it myself and I know of several who actually check the box for it to compact on close (which I feel may be overkill).

But, then again you might do some more searching and see what some of the Microsoft Access MVP's say.

 

[VegaLA]

Thanks Bob.

Aw, I see you are based in Portland, I was there just last month. Nice City.

 

[boblarson]

Nice City.

I like it.