Copy a table across database diagrams (ADP)

Microsoft Office Access 2003

Copy a table across database diagrams (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

You can copy a table from one database diagram to another in the same database.

Copying a table from one database diagram to another database diagram merely adds a reference to the table in the second database diagram. The table is not duplicated in your database. For example, if you copy the authors table from one database diagram to another, each database diagram references the same authors table in the database.

  1. For the source and target database diagrams, in the Database window, click Database Diagrams Button image under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
  2. In the source database diagram, select the table that you want to copy to the target database diagram.
  3. Click the Copy button on the toolbar. This action places the selected table definition on the Clipboard.
  4. Switch to the target database diagram. This database diagram must be in the same database as the source diagram.
  5. Click the Paste button on the toolbar. The Clipboard contents appear at the new location and remain highlighted until you click elsewhere. If relationships exist between the selected tables and other tables in the target database diagram, relationship lines are automatically drawn.

When you edit the table in either database diagram, your changes are reflected in both database diagrams. Similarly, once you save the table in either database diagram, the table is no longer considered "modified" in either database diagram.