Copy or move an Access file

Microsoft Office Access 2003

  • 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:
    • To copy the file, click Copy on the Edit menu.
    • To move the file, click Cut on the Edit menu.

  • 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 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.

    Show 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.