Hide a table in a database diagram (ADP)

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

You can hide a table in your database diagram. Hiding a table does not alter your database. The table and its relationships to other tables continue to exist in the database.

If you hide a table that has been changed either by you or another user, a message prompts you to save the table before hiding it:

• If you save the table before removing it, the database is updated with the changes.
• If you discard changes to the table before removing it, the table remains in memory in its modified state until you save the table or close the last open database diagram, even though the table no longer appears in your diagram.

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 your database diagram, select the table you want to remove.
3. Right-click the table and choose Hide Table from the shortcut menu.

   If the table has unsaved changes as a result of edits you made in the database diagram, a message prompts you to save the table before removing it.

The table is hidden from your database diagram but it continues to exist in the database.