Can somebody figure out what is wrong with this sql statement for access97. It doesnt seem to acknowledge the default value i set for the column I am adding.
Code:
ALTER TABLE Tbl_Partners ADD Question1 integer DEFAULT 0