Compact/Repair Who What When?

[dschomburg]

I was wondering what is really happening when you run these. How often should you run them ?
Which Order should you run them?

Just courious.

Dave

 

[tlbroadbent]

Run Compact regularly to eliminate 'white space' in MDB files. This will help reduce the database size. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[dschomburg]

So are they something like a defrag?
P.S. great qoute!

 

[tlbroadbent]

Yes... sonmething like defrag. Like a disk becomes fragmented as files are added and deleted, an MDB develops a form of fragmentation each time an object is deleted and ofen when objects or data are updated. When MSAccess cannot replace an object back on the same page it was on originally, it creates a new page and writes the object or data there. The old pages are marked as deleted. Compacting removes the deleted spaces when Access rewrites the database to another file.

Repair also rewrites the data. It attempts to correct any problems found in the database structure.

In Access 2000, there is only one choice, Compact and Repair. Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost

 

[dschomburg]

Thanks for clearing that up