title: SQL to add column with default value - Access 2003
body: <p>Updating an old ASP/Access site for a client - I need SQL to add a column to an existing table and set a default value. Doesn't work - any ideas?</p>
  
  <p>This works fine</p>
  
  <pre><code>ALTER TABLE documents ADD COLUMN membersOnly NUMBER
  </code></pre>
  
  <p>I want this to work:</p>
  
  <pre><code>ALTER TABLE documents ADD COLUMN membersOnly NUMBER DEFAULT 0
  </code></pre>
  
  <p>Have googled and seen instructions for default values work for other field types but I want to add number. Thanks!</p>