make table query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Thanks,
Click to expand...

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]
 
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.
 
Back
Top