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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Executing a make-table query using multiple primary keys 8
Edit primary key values 3
Make-table issue 2
Set primary key with make table query 1
Changing existing primary key to autonumber 2
Query from multiple tables 1
2 queries with link table 1
Update primary key field with multiple "where" clauses 0

Back
Top