Back up a database

1. Close the database. If you are in a multiuser environment, confirm that all users have closed the database.
   
   
2. Using the Windows Explorer, My Computer, Microsoft Backup, the MS-DOS copy command, or other backup software, copy the database file (an .mdb file) to a backup medium of your choice.

Notes  

• If you are backing up to a floppy disk and your database file exceeds the size of the disk, you cannot use Windows Explorer or My Computer to back up your database; you must use Microsoft Backup or backup software so that you can copy the file over more than one disk.
  
  
• 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.
  
  
• You can't use the FileCopy statement in a second instance of Microsoft Access to back up a database you have open in the first instance of Microsoft Access.