Alter Table Add Column With Default value

Hi,
How can i Add Column into a table with Default Value option in Access
Database?
I have given the following command but showing error"

ALTER TABLE tbl ADD COLUMN rrr Number Default 0

Thanks,

On Tue, 8 Feb 2005 19:00:31 +0530, "DMP" <debdulal.mahapatra.DeleteThis@fi-tek.co.in> wrote:

¤ Hi,
¤ How can i Add Column into a table with Default Value option in Access
¤ Database?
¤ I have given the following command but showing error"
¤
¤ ALTER TABLE tbl ADD COLUMN rrr Number Default 0
¤

You may have to use DAO for this. I'm not aware of any way to specify the Default value for a column
in Access using Jet DDL SQL.


Paul ~~~ pclement.DeleteThis@ameritech.net
Microsoft MVP (Visual Basic)