Friday, August 28, 2015

Materi Microsoft Access : compact and repair the current database



How to compact and repair the current database :
  1. If you have the database open in read-only mode, click File, Open, and then use the Open dialog box to open the database by using the Open Exclusive option.  If more than one person has the database open, ask each user to close the data-base, and then use the Open dialog box to open the database by using the Open Exclusive option.
  2. Click the File tab, and then click Info.
  3. Click Compact & Repair Database

How to compact and repair a database that isn’t currently open :
  1. Close any open databases.
  2. On the Database Tools tab, in the Tools group, click Compact and Repair  Database.
  3. In the Database to Compact From dialog box, select the database you want to compact, and then click Compact.
  4. In the Compact Database Into dialog box, enter a name for the compacted data-base, and then click Save.
  5. If you used the current name of the database, click Yes in the message box Access displays to confirm that Access should replace the current database file.

No comments:

Post a Comment