How to Copy a Microsoft Access Database

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

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

Open Windows Explorer and navigate to the folder which contains the database you want to copy.

Step

Right-click on the file name and select "Copy" from the pop-up menu.

Step

Navigate to the folder where you want to put the copy of the database.

Step

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

Open Microsoft Access.

Step

Open the database you want to copy in Microsoft Access.

Step

Click on the "Office button" at the top left of the window.

Step

Place your mouse cursor over the "Save As..." menu item but do not click on it.

Step

Select "Access 2007 Database" from the list of "Save As..." options that appear to the right. A pop-up dialog will appear.

Step

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

Open Microsoft Access.

Step

Open the database you want to copy in Microsoft Access.

Step

Click on the "File" menu and select "Save Database As". A pop-up dialog box will appear.

Step

Navigate to the folder where you want to place the new file, type in the name you want to give it, and press "OK"