Copy a database object

Copy a database object within a Microsoft Access file

1. In the Database window under Objects, click the type of database object that you want to copy.
2. In the Object list on the right side of the Database window, click the object and then click Copy on the toolbar.

   If you are copying the object to a different Microsoft Access database or Microsoft Access project, close the current Access database or Access project, and then open the Access database or Access project into which you want to paste the object.

3. Click Paste on the toolbar.
4. Type a unique name for the object in the Paste As dialog box.

   If you are in an Access database that is a Design Master, and if you want the new object to be replicated to other databases, select the Make Replicable check box.

Copy the structure of a table or append data to an existing table

1. In the Database window under Objects, click Tables.
2. In the Object list on the right side of the Database window, click the table whose structure or data you want to copy, and then click Copy on the toolbar.
3. Click Paste on the toolbar.
4. Do one of the following:

   To paste the structure of the table, click Structure Only under Paste Options.

   To append data, in the Table Name box, type the name of the table you're appending data to, and then click Append Data To Existing Table.

Copy a database object to another instance of Access or to another Microsoft application

You can copy a table, query, or report to another Microsoft application that is running on your computer.

1. For each program except Microsoft Access and the application that you want to copy the object to, click the Minimize button in the upper-right corner of the window.
2. Right-click the Microsoft Windows task bar, and then click Tile Windows Vertically.
3. Drag the object from the Database window to the other application.