Compacting and Repairing a Database

graphics/microsoft281_1.gif

What do you do when your database starts acting erratically, or when even the simplest tasks cause Access to crash? Problems of this type can occur when a database gets corrupted or when the database file becomes too large. A database can become corrupted when, for example, Access suffers a system crash. Access can repair many of the problems associated with a corrupted database. The size of the database file may also be the trouble. When you delete objects such as forms and reports , Access does not reclaim the space they occupied. To use this space, you have to compact the database, allowing Access to rearrange the data, filling in the space left behind by the deleted objects.

Compact and Repair a Database

graphics/1_icon.jpg

Make sure all users close the database.

graphics/2_icon.jpg

Open the database with administrative privileges.

graphics/3_icon.jpg

Click the Tools menu, and then point to Database Utilities.

graphics/4_icon.jpg

Click Compact And Repair Database.

graphics/12inf14.jpg



Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net