title: SQL (access) - add a new field to a composite primary key
body: <p>I have a table called table1 which has a composite primary key using 'ScreenId' and 'ActivityItemId'.  I have added a new field 'ProductId' which has a NOT NULL constraint.  I want to add ProductId to the composite primary key. </p>
  
  <p>I thought that this would work</p>
  
  <p>db.execute "ALTER TABLE table1  PRIMARY KEY (ScreenId, ActivityItemId, ProductId)"</p>
  
  <p>but i get an error, i think this syntax only works when creating a table.  </p>
  
  <p>Can anyone help me out with the SQL?  (i can't use a visual basic solution here btw, i'm actually using a ruby interface in order to run the sql, so it needs to be just in SQL)</p>
  
  <p>thanks
  max</p>