1 / 4

Backing Up a Database

Backing Up a Database.

bran
Download Presentation

Backing Up a Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Backing Up a Database You make a backup copy of a database to protect your database against loss or damage. You can make the backup copy using one of several methods: Windows Explorer, My Computer, Microsoft Backup, or other backup software. If you back up your database to a floppy disk, and the file exceeds the size of the disk, you cannot use Windows Explorer or My Computer; you must use Microsoft Backup or some other backup software so that you can copy the file over more than one disk.

  2. Restoring a Database If your database is damaged or you lose it, you can restore it by copying the latest backup copy you made. To restore a database file that you have backed up, choose the same method you used to make the backup copy. For example, if you used the Microsoft Backup tool—a System Tool Accessories available from the Programs menu—you must choose the Restore option for this tool to copy the database file to your database folder.

  3. Compacting a Database Whenever you open an Access database and work with it, the size of the database increases. Likewise, when you delete records or database objects—such as queries, forms, and reports—the space occupied by the deleted records or objects on disk does not become available for other records or objects. To make the space available, you must compact the database. Compacting a database rearranges the data and objects in the database to make its size smaller.

  4. Repairing a Database When you compact a database, Access repairs the database at the same time. In many cases, Access detects that a database is damaged when you try to open it and gives you the option to compact and repair it at that time. If you think your database might be damaged because it is behaving unpredictably, you can use the Compact and Repair Database option, which you can find on the Database Utilities submenu on the Tools menu.

More Related