View Full Version : are they safe to do? (compacting databases)


asp_learner
08-10-2001, 04:32 AM
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
08-10-2001, 05:04 AM
compacting removes temporary information created when you use the db.

yes it is safe.

Ian

harrisw
08-10-2001, 07:50 AM
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.