Understanding how to manage database files is part of effectively using Microsoft Access. At times, for purposes such as backing up or testing, it becomes necessary to know how to make a copy of an Access database file. Unlike other products in the Microsoft Office family, however, Access does not have a straightforward way of copying a file. Depending upon the version of Microsoft Access you are using, the steps for making a copy of a database file are different.
Instructions for Microsoft Access 2003 or earlier
Video of the Day
Step 1
Completely close the Microsoft Access database you wish to copy. Confirm this by verifying that no Access windows are open in the WIndows "Start" bar.
Video of the Day
Step 2
Open Windows Explorer and navigate to the folder which contains the database you want to copy.
Step 3
Right-click on the file name and select "Copy" from the pop-up menu.
Step 4
Navigate to the folder where you want to put the copy of the database.
Step 5
Use the Paste feature to paste a copy of the database in the folder. You now have made a new copy of the database.
Instructions for Microsoft Access 2007
Step 1
Open Microsoft Access.
Step 2
Open the database you want to copy in Microsoft Access.
Step 3
Click on the "Office button" at the top left of the window.
Step 4
Place your mouse cursor over the "Save As..." menu item but do not click on it.
Step 5
Select "Access 2007 Database" from the list of "Save As..." options that appear to the right. A pop-up dialog will appear.
Step 6
Navigate to the folder where you want to place the new file, type in the name you want to give it, and press "OK"
Instructions for Microsoft Access 2010
Step 1
Open Microsoft Access.
Step 2
Open the database you want to copy in Microsoft Access.
Step 3
Click on the "File" menu and select "Save Database As". A pop-up dialog box will appear.
Step 4
Navigate to the folder where you want to place the new file, type in the name you want to give it, and press "OK"