<div>
You miss a space:<br />

<pre><code class="code-1 nolinks" id="code-20-41816521-1"><span>dbs.Execute &quot;ALTER TABLE RawList&quot; &amp; &quot; &quot; &amp; &quot;ADD COLUMN TimesUsed INTEGER(10);&quot;</span>
</code></pre>
/gustav
</div>


<div>
I copied and pasted your code into mine, still getting the syntax error. :(
</div>


<div>
Is there any specific reason you need two separate strings???<br />
<br />
dbs.Execute &quot;ALTER TABLE RawList ADD COLUMN TimesUsed INTEGER(10);&quot;<br />
<br />
<br />
ET
</div>


<div>
Nope, no reason other than that's how Microsoft's example worked. &nbsp;I tried your suggestion, still getting the syntax error.
</div>


<div>
I think the syntax is ... &nbsp;<br />
<br />
dbs.Execute &quot;ALTER TABLE RawList ADD TimesUsed INTEGER;&quot;<br />
<br />
<br />
ET
</div>


<div>
Ha! &nbsp;That's it! &nbsp;Thank you, Gustav!
</div>


<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
I'm using an example of the Alter Table statement from Microsoft's Developer Network website (<a href="https://msdn.microsoft.com/en-us/library/bb177883(v=office.12).aspx" rel="ugc">https://msdn.microsoft.com/en-us/library/bb177883(v=office.12).aspx</a>), but I'm getting a syntax error. &nbsp;I changed the table and column names, but other than that, it's exactly like Microsoft's example. &nbsp;The table was created earlier with a make-table query. &nbsp;What am I doing wrong?<br />
<br />
Set dbs = CurrentDb<br />
dbs.Execute &quot;ALTER TABLE RawList&quot; &amp;&nbsp;&quot;ADD COLUMN TimesUsed INTEGER(10);&quot;<br />
<br />
I browsed topics and solutions, but didn't find an answer. &nbsp;TIA for any suggestions...
</div>
</div>


I'm using an example of the Alter Table statement from Microsoft's Developer Network website (https://msdn.microsoft.com/en-us/library/bb177883(v=office.12).aspx), but I'm getting a syntax error.  I changed the table and column names, but other than that, it's exactly like Microsoft's example.  The table was created earlier with a make-table query.  What am I doing wrong?

Set dbs = CurrentDb
dbs.Execute "ALTER TABLE RawList" & "ADD COLUMN TimesUsed INTEGER(10);"

I browsed topics and solutions, but didn't find an answer.  TIA for any suggestions...

Syntax error in Alter Table statement

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.