<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>

Tools -> Options -> Tables/Queries -> (At the bottom right:) Sql Server Compatible Syntax - turn option on for this database.
then you can execute your query:
```
```
ALTER TABLE documents ADD COLUMN membersOnly NUMBER DEFAULT 0
```
```