Make Table Query with Primary Key

  • Thread starter Thread starter DW
  • Start date Start date
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
 
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
 
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!
 
Back
Top