Objective 1.4 Protect and maintain databases

  • 1.4.1 Compact and repair databases
  • 1.4.2 Back up and restore databases
  • 1.4.3 Split a database
  • 1.4.4 Encrypt database files

OBJECTIVE 1.4: Contents

Access provides several options for maintaining and protecting a database. The first of these—Compact & Repair—can help improve the performance of a database and can repair database files in the event of a problem. You can use the Encrypt With Password option to restrict database access to only those users who know the password.

This topic describes these options and other tasks you perform to protect and maintain a database, including backing up a database, recovering data from a backup, and splitting a database—a step that applies especially to a database shared by multiple users.

  • 1.4.1 Compact and repair databases
  • 1.4.2 Back up and restore databases
  • 1.4.3 Split a database
  • 1.4.4 Encrypt database files