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

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