The need to compact and repair? 1

[leonepaolo]

Hi,

I have several mdb files that are used for reference purposes only. I link to them and I create run-time connections to them to retrieve the data I need. Do I need to compact and repair these files?

Any comments or suggestions are greatly appreciated.

Thanks in advance,
Paolo

 

[Zion7]

Not if new data is not being added.
It should be compacting on close, by selecting that option
from the Tools>Options >General dialog.

but once compacted, & it doesn't enlargen, I don't believe you neeed to re-compact.

Repair, only if becomes corrupt. Since you're not editing,
or running programs from it, it shouldn't become corrupt.

 

[TheAceMan1]

How are ya leonepaolo . . .

A good critique on [blue]Compact & Repair[/blue]:

Description of the Compact and Repair Utility

See Ya! . . . . . .