Set primary key when using make table query

[Bkper087]

Keeping it simple: how can I set a field to serve as the primary key of a table using a make table query? I need to run this query to update the information regularly and I don't want to have to remember to go in and reset the PK in design mode. Is there any way to set this using the query functions or in SQL mode?

[June7]

Advise to avoid implementing code that routinely modifies db design. If possible, use a 'temp' table - table is permanent but records are temporary. Delete records before running process. If this is a multi-user split db, temp tables should be located in frontend.

MAKE TABLE query cannot accomplish. Requires CREATE or ALTER sql actions or VBA using TableDefs.

Why would you need an autonumber field in a table that has temporary life?

[isladogs]

Agree with June. Avoid make table queries wherever possible.
However this code will add an autonumber PK field to an existing table

 CurrentDB.Execute "ALTER TABLE YourTableName ADD COLUMN ID COUNTER(1, 1) NOT NULL PRIMARY KEY;"

Alternatively use a CREATE TABLE method and append the data to the new table
For more details, see https://www.w3schools.com/sql/sql_primarykey.asp