Copy or move an Access file

  1. Close the Microsoft Access file (Microsoft Access file: A database or project file. In Access 2007, database objects and data are stored in .accdb files. Earlier versions use.mdb files. An Access project file doesn't contain data, and is used to connect to a SQL Server database.). If you are using an Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) in a multiuser (multiuser (shared) database: A database that permits more than one user to access and modify the same set of data at the same time.) environment, confirm that all users have closed the file.
  2. In My Computer, find the database (.mdb) or project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects, such as tables and views.) (.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.

  1. 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.
  2. Open the folder or disk where you want to put the file or files.
  3. On the Edit menu, click Paste.

To undo the paste operation, click Undo Copy or Undo Move on the Edit menu.

 Notes 

ShowTip

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.

 
 
Applies to:
Access 2003