Hi all

I try to set default value to be 1 but it does not work!

Help me please.



sql1 = "ALTER TABLE Detail ADD COLUMN EngNum int NOT NULL DEFAULT 1"



I use MS-Access. 

Hello!



Is it possible that you could just make alter table with sql and then open 

the table in design view and set the default there?

Sanna



> Hi all

> I try to set default value to be 1 but it does not work!

> Help me please.

> 

> sql1 = "ALTER TABLE Detail ADD COLUMN EngNum int NOT NULL DEFAULT 1"

> 

> I use MS-Access.