Unanswered: MA Access Alter Table Default Column Value
Is there any way to add a Default Value for a field in Access, when that particular field is being created in the Table.
Currently I am using
ALTER TABLE tbl ADD COLUMN rrr Number and that works fine. But I want it to have a default value of 0 (Zero).
So i put in ALTER TABLE tbl ADD COLUMN rrr Number Default 0 and it doesn't work. Can anyone please help me. I don't want to do it in the VBA. I want to do it using the Alter Table command