Set primary key for make-table Table??? (1 Viewer)

[wrek]

Hi Access gurus,

How do I set a certain field to be a primary key, when I construct the table using a make table query?

Is there a VBA property for primary key?

Thanks. your disciple,

wrek

 

[araskas]

CREATE TABLE myTable
(fld1 LONG CONSTRAINT myKey PRIMARY KEY,
fld2 TEXT .....)