title: MS Access set cascade-to-null constraint to existing table
body: <p>Using a MS Acess 2007 database accessed by vb.net application
  I have two existing table</p>
  
  <pre><code>Members
  -------
  ID     name     bandID
  -----------------------
  0      Pierre   1
  1      Chart    3
  2      John     3
  3      Dave     2  
  
  Bands
  -----
  ID     bandName
  ----------------
  1      Band a
  2      Band b
  3      Band c
  </code></pre>
  
  <p>I want to add an cascade to null constraint to the relation between members.bandId and bands.ID</p>
  
  <p>This is what I have</p>
  
  <pre><code>ALTER TABLE members ADD CONSTRAINT membresBands_FK
      FOREIGN KEY (bandID) REFERENCE Bands(ID) ON DELETE CASCADE SET NULL
  </code></pre>
  
  <p>But I get this error message:</p>
  
  <blockquote>
    <p>Syntax error in CONSTRAINT clause</p>
  </blockquote>
  
  <p>From msdn I found</p>
  
  <pre><code>CREATE TABLE Orders 
    (OrderId INTEGER PRIMARY KEY, 
    CustId INTEGER, 
    OrderNotes NCHAR VARYING (255), 
    CONSTRAINT FKOrdersCustId FOREIGN KEY (CustId) 
    REFERENCES Customers ON UPDATE SET NULL ON DELETE SET NULL
  </code></pre>
  
  <p>Is it possible to alter a table in MS Access to set relationship to cascade to null?</p>
  
  <p>Thank you!</p>