Save selected tables on a database diagram (ADP)

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

You can save a specific table or a set of tables if you do not want to save all the changes you made in a database diagram.

1. In your database diagram, select the tables you want to save.
2. In the Database Designer, click Save .
3. The Save dialog box displays the list of tables that will be updated in the database when you save your selection.

   Choose Save Text File if you want to save the list of tables in a text file in the project directory before continuing. When a message box displays the name of the saved text file, choose OK.

4. In the Save dialog box, confirm the list of tables and choose Yes to save these tables.

   Note   The list of tables may contain tables in addition to those selected. For example, if you change the data type of a column that participates in a relationship with another table, both tables will be included in this list.