How to Copy a Microsoft Access Database

By DaveB

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

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.

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"

Tips & Warnings

  • If you are unsure as to which version of Access you have, use the instructions for "Microsoft Access 2003 and earlier". Those instructions will work for all versions of Access.