How to Copy a Microsoft Access Database

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Advertisement

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.

Advertisement

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.

Advertisement

Instructions for Microsoft Access 2007

Step 1

Open Microsoft Access.

Step 2

Open the database you want to copy in Microsoft Access.

Advertisement

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.

Advertisement

Advertisement

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.

Advertisement

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"

Advertisement

Advertisement

references