I want to create a field with a default value in a table of a Microsoft Access 2000 base via a SQL command :
ALTER TABLE MyTable ADD COLUMN MyField INTEGER DEFAULT 0;

Then I have a syntax error in my request. In the Microsoft Access help, the DEFAULT parameter seems authorized but in fact it doesnot work.

May be it exist another meaning to attribute a default value for a field by SQL request. Can you tell me if it is the case ?

Note : With a SQL Server base I have no problem.