Make Table Query - Adding Primary Key and Index

[Guest]

How do you add (in run-time) primary key and indexing to a table (during
creation or after creation) when it has been created through a make-table
query? Either from a designed query or VBA SQL statement.

 

[Guest]

I wouldn't recommend doing that. Instead create an Append query so that you
can setup the table prior tho the append. A maketable is just for dumping
temp data so why bother adding indexes to them. Create the table, set the
key, add indexes and append the records you want from the query you use to
make the maketable.