Microsoft Office Tutorials and References
In Depth Information
If you use Access at work, consult your system administrator. If you store
your Access databases on a network drive, the databases may be backed up
for you automatically on a regular basis.
Backing up part of a database
You may want to back up only part of your database, such as a few tables
containing data that changes frequently. You can export objects to another
Access database for backup. The first order of business is creating a blank
database to which you can export objects; then, when the objects have
someplace to go, you can export them.
Creating a blank database
Follow these steps to create a new, blank database:
1. Click the File tab of the Ribbon, and choose Close to close the
database you’re working with (if any).
Don’t close the Access window. Stay in Backstage View. You still need to
use Access for this task.
2. Click the Blank Desktop Database button.
A dialog box appears, with a suggested filename, a folder icon, and a
3. Click the folder icon to the right of the File Name box, and browse to
the folder where you want to place the database.
4. Give the database a meaningful name (ideally, one related to the
database that you’re backing up, such as MyDBbackup).
5. Click the Create button.
Access displays a new, blank database and opens a new, blank table to
encourage you to start.
6. Close your new backup database.
Now, with no database open, Access looks pretty empty. The next section,
“Exporting database objects,” shows you how to populate the new
Exporting database objects
Follow these steps each time you want to back up an object in your Access
1. Open the database that contains the object that you want to export.
2. In the Navigation Pane, select the object that you want to export.