Copy or move an Access file
- Close the Microsoft Access file.
If you are using an Access database
in a multiuser environment, confirm that all users have closed the
file.
- In My Computer, find the database (.mdb) or project
(.adp) file and then click it.
To select more than one file to copy or move, hold down the CTRL key and click each file.
- Do one of the following:
- Open the folder or disk where you want to put the file or files.
- On the Edit menu, click Paste.
To undo the paste operation, click Undo Copy or Undo Move on the Edit menu.
Notes
- When you copy or move an Access database or Access project that contains links to data access pages, Access leaves the pages in their original folder and automatically updates links to the pages so they continue to work as before.
If you move both the Access file and the pages, you must change the Path property of each page. You must also change the
Connection property of each page, or edit the appropriate
ODC file.
- When you copy or move an Access project file, you are not copying or moving the
Microsoft SQL Server database
to which the Access project is connected.
- If you copy or move an Access database, and another database includes links to objects in that database, use the Linked Table Manager in the other database to update the link information. Otherwise, Access will produce an error when you try to use those linked objects in the other database.
Tip
If the destination where you're placing the file is already visible, you can quickly move the file by dragging it to the new destination, or you can copy the file by holding down the CTRL key while you drag the file.