|
How do I back up a Microsoft Access database?
Category: Backup
| Hits: 10243
Related Link: http://www.remotedatabackups.com/why/backup_files.cfm?afile=Access
(This information is taken from the Microsoft Access help files.) To back up an access database: - Save and close all objects in the database. On the File menu, click Back Up Database. In the Save Backup As dialog box, specify the name and location of the backup copy.
Caution: If you are using user-level security (user-level security: When using user-level security in an Access database, a database administrator or an object's owner can grant individual users or groups of users specific permissions to tables, queries, forms, reports, and macros.), you should also create a backup of the workgroup information file (workgroup information file: A file that Access reads at startup that contains information about the users in a workgroup. This information includes users' account names, their passwords, and the groups of which they are members.). If this file is lost or damaged, you won't be able to start Microsoft Access until you restore or rebuild it. - Make sure you select your .mdb file from the Remote Data Backups' Backup View / Select Files to Back Up view.
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 or later 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.
Note: You can back up individual database objects (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.) by creating a blank database and then importing the objects you want from the original database.
| 
