Securing and Administering Access - Back Up Individual Database Objects

(Page 9 of 11 )

If you want to back up only a few objects instead of the whole database:

1. Create a new empty database.
   
   
2. Click File | Get External Data | Import.
   
   
   
   
3. Locate and select the database in the Import dialog box. Click Import.
   
   
4. Click each tab in the Import Objects dialog box, as shown in Figure 9-13, and select the objects you want. See the section, “Import Data from Outside Sources,” in Chapter 4 for more information about importing.

   Figure 9-13: You can import objects into the backup database.

   
   
   

5. Click OK to import the objects.
   
   
6. Save the new database.

NOTE  By default, the new database assumes the Access 2000 format, unless you’ve changed the default settings. See Chapter 1 for more information about changing default settings.

TIP  Some defi nitions can cover many pages. Be sure to check how many before you start to print.

Restore a Database

When you need to restore the database from the backup copy, use the recovery tool for the method you used to create the backup. For example, in Windows Explorer you may simply drag the fi le name back to the original folder on the hard drive.

NOTE  You can save the Documenter’s report as a Report Snapshot; an Excel worksheet; or in another format, such as HTML or RTF. (See Chapter 7 for information on creating a Report Snapshot.)

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: Database Administration >>
 

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!