ALTER TABLE column with default value

  • Thread starter Thread starter Francesco Sarzana
  • Start date Start date
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???
 
This syntax may only be supported by the Microsoft Jet OLE DB Provider (not
the Microsoft OLE DB Provider for ODBC).
 
Back
Top