Set primary key using macro

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

Is there a way to set a field in a table as the primary
key in either the make table query or in a macro? Thanks.
 
Lynn,

I think the only way you could do this with a macro is to use a RunSQL
macro action, and enter a ALTER TABLE statement for the SQL Statement
argument of the macro. You can find more information by looking in
Access Help at the CONSTRAINT Clause topic.
 
Back
Top