Duplicate a table (ADP)

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

A table can appear only once in a database diagram. However, if you want to create a new table that contains some or all of the same columns as an existing table in your database diagram, you can duplicate the existing table as the first step in creating your new table. Then in your new table, you can delete unwanted columns, add new columns, and assign a unique table name.

Note   This operation duplicates only a table’s structure; it does not duplicate any table data.

Use the same technique for duplicating tables across database diagrams.

1. In the Database window, click Database Diagrams under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In the database diagram where you want to duplicate the table, right-click the diagram and choose New Table from the shortcut menu.
   -or-
   Click the New Table button on the Database Diagram toolbar.
3. In the Choose Name dialog box, accept or change the system-assigned name of the new table and click OK.
   A blank table is added to your database diagram.
4. In the table you want to duplicate, select all the columns. This table can be in the same database diagram, a different database diagram in the same database, or a database diagram in a different database.
5. Copy the columns to the blank table.