O'Reilly logo

Ten Minute Guide to Access 97 by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Repairing Damaged Database Files

In most cases, when you try to work with a damaged database, Access will detect it and offer to repair the database. But if your database is damaged and Access does not detect it, follow these steps to repair it:

  1. Close all databases.

  2. Select Tools, Database Utilities, Repair Database.

  3. Select the database you want to repair, then click Repair. Access repairs it.

After you run Repair you should always run Compact. Compacting makes a copy of your database and leaves the original. Compacting also rearranges how the database file is stored to make better use of disk space. To Compact a database, open the database and select Tools, Database Utilities, Compact Database. The compacting process is totally automatic; no ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required