make table query

[Guest]

Is there anyway to assign a field as the primary key when using a make table
query?

Thanks,

 

[John Vinson]

Is there anyway to assign a field as the primary key when using a make table
query?

Thanks,

Not really. You can create the table using DDL queries and then run an
Append query to populate it, instead of using a MakeTable; or you can
run another DDL "Alter Table" query after it's created to define the
PK.

In my experience, MakeTable queries are *rarely* needed. Why do you
feel that you need to (routinely!?) create a new table? What purpose
does this table serve which could not be served by a Select Query, or
by having a "work" table which is repeatedly emptied and refilled?

John W. Vinson[MVP]

 

[Access G-man]

I am not familiar with a DDL query, It sounds like that is what I am after. I
want to make a second table for inactive equipement and not loose the
maintenance performed records related to it.