When you delete a record from a database, the space allotted for that record continues to be held in reserve by the database and it is not released for reuse. Likewise, extra space, created by modifying and shortening records, is not released for reuse. If you never compact your database, your database will retain the "wasted" space and continue to consume additional space to accommodate additional data. This can cause corruption in your database and fragment the data. So yes, you should compact your database on a regular basis. Here is how.
1. Open the database. 2. Go to the TOOLS menu, choose DATABASE UTILITIES, and then COMPACT AND REPAIR DATABASE.
Your database will automatically close and reopen.
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in OneStopFAQs.com:-
There should not be any Spelling Mistakes.
There should not be any Gramatical Errors.
Answers must not contain any bad words.
Answers should not be the repeat of same answer, already approved.