Show All

Hide All

1. Close the Microsoft Access file (Microsoft Access file: An Access database or Access project file. An Access database stores database objects and data in an .mdb file. A project file doesn't contain data and is used to connect to a Microsoft 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. The Microsoft Jet database engine manages the data.) 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.

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

4. Open the folder or disk where you want to put the file or files.
5. 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 (Microsoft SQL Server database: A database in Microsoft SQL Server, it consists of tables, views, indexes, stored procedures, functions, and triggers.) 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