Microsoft Office Tutorials and References
In Depth Information
3. Click Info (if it isn’t selected already) and then click Compact & Repair
Access compacts the database. When the status indicator at the bottom
of the Access window hits 100 percent, and the mouse pointer no longer
looks like an hourglass, the compacting is complete. If you don’t see any
error messages, the compacting worked perfectly and needs no repairs.
If your computer is on a network, and you suspect that other people are
using your database, make sure that no one else has your database open
before compacting it.
Backing up your database is vital. If you’re not sure, think about the amount
of effort it took to create the database. Think about how furious your boss
would be if the database vanished from your hard disk. Think about the
killing boredom of typing all that information again. Okay, you get the idea:
Backups are good things.
Ideally, you should back up your entire hard drive — at least, the files that
you create or edit. (Backing up program files usually is pointless: You should
have all the CDs or downloaded executable installation files to reinstall your
programs, if need be.) A good backup system creates regular backup copies
of all your files — perhaps all the files in your Documents or My Documents
folder — on tapes, writeable CDs, writeable DVDs, or another hard disk
(such as your organization’s file server).
Backing up a whole database
Follow these steps to back up your whole database:
1. Click the File tab of the Ribbon, and choose Save As.
2. In the File Types section of the screen, make sure that Save Database
As is selected.
3. In the Advanced heading, select Back Up Database.
4. Click the Save As button.
The Save As dialog box appears, displaying your database name (with
today’s date appended) in the File Name field.
Clicking the Save button at this point saves the database in the default
location. If you want to save it somewhere else, you can change the
folder in the folder drop-down menu at the top of the dialog box.
5. If you want to save the database somewhere other than the default
location, navigate to the folder where you want to store the backup.
6. Click Save.