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
Printable View
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
append??