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
More Related Contents:
- sql in ms-access [closed]
- Managing and debugging SQL queries in MS Access
- SQL multiple join statement
- How do I write a full outer join query in access
- What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
- How to do INSERT into a table records extracted from another table
- Multiple INNER JOIN SQL ACCESS
- Table-less UNION query in MS Access (Jet/ACE)
- SQL Query – Using Order By in UNION
- Ms Access Query: Concatenating Rows through a query
- Access-SQL: Inner Join with multiple tables
- is there a group_concat function in ms-access?
- How do I implement pagination in SQL for MS Access?
- [] brackets in sql statements
- Row numbers in query result using Microsoft Access
- Achieving ROW_NUMBER / PARTITION BY in MS Access
- How can I implement SQL INTERSECT and MINUS operations in MS Access
- Lightweight SQL database which doesn’t require installation [closed]
- Convert String to Date in MS Access Query
- HOW TO SELECT PREVIOUS ROW VALUE? [duplicate]
- MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
- Editing Record issues in Access / SQL (Write Conflict)
- How do I create a table alias in MySQL
- Select query with date condition
- Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
- Microsoft Access – Case Query
- SQL SET DEFAULT not working in MS Access
- CONCAT equivalent in MS Access
- Check if access table exists
- Access substitute for EXCEPT clause