are they safe to do? (compacting databases)

[asp_learner]

Hi,

I just compacted a copy of my database and it went from 35,000,000 bytes to 10,000,000 bytes.

Just want to make sure that it is safe.

Eva

 

[Fornatian]

compacting removes temporary information created when you use the db.

yes it is safe.

Ian

 

[harrisw]

Yes perfectly safe.

I think what acces does is get bigger to accomodate tables that you create. However when you delete a table access doesn't shrink in size. You can delete all the tables and it will still stay the same size it was with the data in it.