Inserting new field in MS Access database.

[Kings]

How can I insert a new field in a MS Access database table. I've already got the following but I can't get it to work with a default value.

ALTER TABLE Articles ADD 'Moderated' number

How do I add a default value?

[jofa]

ALTER TABLE Articles
ADD COLUMN Moderated NUMBER DEFAULT 99

or, if the column exists
ALTER TABLE Articles
ALTER COLUMN Moderated SET DEFAULT 99

[jofa]

And... don't forget:
UPDATE Articles SET Moderated = 99
after adding the column, because all existing rows in the table will get Moderated = NULL

[Kings]

Thank you very much

[Kings]

Those SQL Querys aren't working. This is an MS Access 2000 db.

[jofa]

This works for me (Access 2000):

strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\filename.mdb"
strSql = "ALTER TABLE Articles ALTER COLUMN Moderated SET DEFAULT 99"
Set objCon = CreateObject("ADODB.Connection")
objCon.Open strCon
objCon.Execute strSql
Set objCon = Nothing

[Kings]

Hmm, I'll use my own code then (I was using a default database editor made by someone else). I'll let you know if it works

[Kings]

Thanks, I think it worked! From now on, I'll be using my own code instead of the default database editor.