Compact and Repair database, IS IT SAFE

[Riaang]

Hi all,

I know it is a simple question but is it safe to Compact and Repair a database.

I realize that it makes the file smaller but does it throw away any data, formulas or formats.

Please give me some peace of mind.

Thanks

 

[SydneyGeek]

It's a good idea and probably should be done on a weekly basis if you use the database a lot. Basically, the more you use the database (and particularly if you regularly modify the structure -- queries, forms, reports, new table fields) the more "holes" it gets.
Compact and repair removes the holes without destroying data, and makes the database less prone to crashing. And you don't want a crash -- recovering a corrupted database is not pretty. By the way, I probably don't need to say it but back up regularly too.

Denis

 

[Legacy 16232]

I agree, Compact and Repair is just like defragging your hard drive, and it's a great thing!

 

[Riaang]

Thanks a lot guys

 

[Riaang]

Thanks a lot guys