Make Table Query with Primary Key

D

DW

It seems that a make table query has no way to assign a primary key. Does
any body know a nother way to get this to work maybe VBA.

Thanks
 
O

Ofer

You can always create the table with the key. and then run two queries
1. Delete the Temp table
2. Insert the new records in the Temp table
 
C

Chaim

You could try using an ALTER TABLE SQL statement with a CONSTRAINT clause.

Take a look in the Access Help Microsoft Jet SQL Reference > ALTER TABLE and
Microsoft Jet SQL Reference > CONSTRAINT Clause.

Good Luck!
 
Top