title: ALTER TABLE Syntax Error
body: <p>I'm having trouble with an update query in Access.</p>
  
  <p>I'm trying to do two things, add a field to a table, and change all values in another field to the same value. </p>
  
  <pre><code>ALTER TABLE 103 ADD COLUMN test TEXT;
  UPDATE 103 SET [103].Workcenter = "103";
  </code></pre>
  
  <p>When I run these two lines independently, they work fine, but when I put them in the same query I get "Syntax Error in ALTER TABLE" statement. Does anyone know why I can't do this?</p>
  
  <p>It would also be great if I could add a column and update all values in that field to a default value. I've tried DEFAULT in the ALTER TABLE command but it's not working either.</p>
  
  <p>Thanks in advance for suggestions!</p>