Back up and restore an Access database
Back up an Access database
- Close the Microsoft Access database. If you are
using the Access database in a multiuser environment, confirm that all users have closed the database.
- Using My Computer, the Microsoft Windows 2000 Backup and Recovery
Tools, or other backup software, copy the Access database to a backup medium of your choice.
Restore an Access database from a backup copy
- Depending on what method was used originally to produce the backup copy, use
My Computer, the Windows 2000 Backup and Recovery Tools, or other backup software to copy the backup Access
database to your database folder.
Caution If the existing Access database in the database folder and the backup copy have the same name, restoring the backup copy may replace the existing
file. If you want to save the existing file, rename it before you copy the backup
database.
Notes
- If
you are using user-level security,
you should also create a backup of the workgroup information file. If this file is lost or damaged, you won't be able to start Microsoft Access until you restore or rebuild it.
- You can back up individual database objects by creating a blank database and then importing the objects you want from the original database.