Existing tables can't be modified. Changes can be used to create a new empty table.

To create a new table from an existing table, you must change the table name in the View Table Definition dialog box. The new table doesn't contain the data that is stored in the existing table. You can't edit existing table definitions in Microsoft Query.