Securing and Administering Access - Back Up and Restore a Database

(Page 8 of 11 )

When working with an important database, it is a good idea to have a backup copy on hand. Creating a backup database on a regular basis can help reduce the risk of losing important data.

Before making a backup copy, make sure all users have closed their databases so all changes in the data have been saved.

You can make a backup copy from either outside or inside of Access. To backup without using Access, do one of the following:

• Right-click the file name in the Windows Explorer window, and point to Send To in the context menu, as shown in Figure 9-11. Click the drive where you want to save the copy.

  Figure 9-11: You can create a backup copy using Send To
  in Widows Explorer.

  
  
  

• After locating the file name in the Windows Explorer window, drag it to another disk in the Folders pane.
  
  
• Use Microsoft Windows Backup and Recovery tools. For example, in Windows XP you can use the Automated System Recovery (ASR) tool (Click Start | All Programs | Accessories | System Tools | Backup | Advanced Mode). You can also use the MSDOS Copy command or a third-party backup utility. (You may also be able to compress the file at the same time.)

Back Up a Database From Access

You can use Access to create a regular copy to keep as a backup copy. No compression or other reformatting takes place—you just create a regular database file.

TIP  By default, the backup fi le keeps the same name with the current date added to it.

1. Click File | Backup Database.
   
   
2. Choose the location for the copy, and type a name for it in the Save Backup As dialog box, as shown in Figure 9-12.

   Figure 9-12: You can also create a backup copy with Access.

   
   
   

3. Click Save.

TIP  If yours is a multi-user environment, be sure to backup the Workgroup Information File, too.

This chapter is from Microsoft Office Access 2003 QuickSteps, by Cronan, Anderson, and Anderson (McGraw-Hill/Osborne, 2004, ISBN: 0072232293). Check it out at your favorite bookstore today. Buy this book now.

Next: Back Up Individual Database Objects >>
 

More Microsoft Access Articles
More By McGraw-Hill/Osborne

Comments On: Securing and Administering Access

· some time ago it was said that the workgroup file is needed to break into a secured...    · I\'m not sure about Access2003... but every other version of access that uses the...   >>> Post your comment now!