Copy a database object

ShowCopy a database object within a Microsoft Access file

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.) under Objects, click the type of database object (database objects: An Access database contains objects such as tables, queries, forms, reports, pages, macros, and modules. An Access project contains objects such as forms, reports, pages, macros, and modules.) 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 Button image on the toolbar.

If you are copying the object to a different Microsoft 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.) or Microsoft Access 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.), 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.

  1. Click Paste Button image on the toolbar.
  2. 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 (Design Master: The only member of the replica set in which you can make changes to the database structure that can be propagated to other replicas.), and if you want the new object to be replicated to other databases, select the Make Replicable check box.

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

  1. In the Database window (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.) 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 Button image on the toolbar.
  3. Click Paste Button image 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.

ShowCopy 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 (Database window: In Access 2003 and earlier, the window that appears when a database or project is opened. It displays shortcuts for creating new database objects and opening existing objects. In later versions, it is replaced by the Navigation Pane.) to the other application.
 
 
Applies to:
Access 2003