Set primary key using macro

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.
 
S

Steve Schapel

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.
 
Top