guys.. i'm using ACCESS 2000.

i wish to add a field
1. fieldname : mytext
2. fieldtype : text
3. default value : none

i have try
ALTER TABLE <TABLE> ADD COLUMN mytext text

but failed to set the DEFAULT value

why not just add the field in table desgin rather than using sql?

why not just add the field in table desgin rather than using sql?

i just to need to how to do that instead of using design method... sure have a solution to do that.... i'm doin runtime app now..the reason is : coz design takes time... running script faster ... pls help me