Securing and Administering Access - Compact and Repair a Database

(Page 11 of 11 )

As you improve and modify your database, the file can become scattered about on your disk with empty blocks of space between. The Compact and Repair Database utility removes the empty spaces and rearranges the file more efficiently to improve performance. If there has been some damage, this utility can find the problems and offer to repair them at once.

You can start the compact and repair process with the database open or closed. With the database open, simply click Tools | Database Utilities | Compact And Repair Database.

TIP  One of the options on the General tab of the Tools | Options dialog allows you to automatically compact a database when you close it if the reduction in size would be greater than 256K. To do this, select the Compact On Close option.

If the database is closed, you can compact and repair it to the same fi le or with a different name in another location.

Figure 9-16: Documenter shows you the documentation
report before you print.

If the compact and repair utility doesn’t work, one of the following problems may exist:

• The database may be open by another user. Wait for the other user to close the database and try again.
  
  
• There is not enough free space for both the original and the repaired database on the disk. Go back and delete unnecessary files, and try again.
  
  
• You may not have the required Open/Run and Open Exclusive permissions.
  
  
• The name of the database from an earlier version of Access may include a character that is no longer permitted, such as the grave accent (`). Return to the earlier version of Access, change the name, and then try again.
  
• The database file may be set to Read Only.

  

This chapter is from Microsoft Office Access 2003 QuickSteps, by Cronan, Anderson, and Anderson (McGraw-Hill/Osborne, 2004, ISBN: 0072232293). Check it out at your favorite bookstore today. Buy this book now.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Securing and Administering Access

· some time ago it was said that the workgroup file is needed to break into a secured...    · I\'m not sure about Access2003... but every other version of access that uses the...   >>> Post your comment now!