Share this Page URL

Chapter 18. Maintaining an Access Databa... > Backing Up an Access Database - Pg. 617

Maintaining an Access Database 617 3. Notice in the File Name box that Access adds the current date (in the format yyyy-mm-dd ) to the name of the database. You can use the name Access provides or enter a name of your own that follows a convention you've established for other files you back up regularly. In this example, we'll use the name Access provides. Open the folder where you want to save the backup (we've used a folder named HelloWorld Backups), and then click Save. After creating and saving a backup copy, Access opens the HelloWorld_be database again. (Depending on your macro security settings, Access might display the Security Warning mes- sage box from which you open the database. Click Open in the message box to open Hello- World_be again.) After you make a copy of the database, you should include it among the other files on a particular computer that you back up regularly. Microsoft Windows XP provides a system ac- cessory named Backup Utility (choose Start, Programs, Accessories, System Tools, Backup to run Backup Utility) that you can use to copy files and folders to media such as a compact disc or an external hard disk. You can use Backup Utility to restore a backup when necessary. See Also Microsoft Windows Security Inside Out (Microsoft Press, 2002), which covers Win- dows XP and Windows 2000, provides detailed information about setting up a regular backup routine as well as other information about securing a computer running Mi- crosoft Windows. See Chapter 06, "Preventing Data Loss," in Microsoft Windows Se- curity Inside Out for information about system backups. Backing Up Individual Database Objects An alternative to backing up an entire database is to create another database file and then export (or import) individual database objects that need to be backed up to the new database. You can accomplish this task by using the Export or Get External Data command on the File menu.