ALTER TABLE column with default value

F

Francesco Sarzana

hi,

i want to add a new column in a MS ACCESS database with a default value.

is this statement wrong?:

ALTER TABLE xxx ADD colyy INTEGER DEFAULT 0

cause i get this error:

Microsoft OLE DB Provider for ODBC Driverserror '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE
statement.


can anyone help me???
 
B

Brian Camire

This syntax may only be supported by the Microsoft Jet OLE DB Provider (not
the Microsoft OLE DB Provider for ODBC).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set default value to 0 with ALTER TABLE 1
ALTER TABLE problems 5
ALTER COLUMN question 1
Making SQL updates to a table named 'COLUMN' 3
Changing the default value of a column in Access using a SQL query 1
SQL Change Column name 5
add a value to a date 8
Default Value 1

Top