Updating "Default Value" attribute to table in external database

[Rod]

Help! I'm able to add a field to a table in an external
database by executing the following code...

Function fncCreateDatUpdate()
Dim db As Database
Dim tdf As TableDef

Set db = DBEngine.OpenDatabase("c:\lacc\smpdata.mdb")
Set tdf = db.TableDefs("tblDonorChild")
Set fld = tdf.CreateField("datUpdated", dbDate)
tdf.Fields.Append fld

How do I modify the "default value" of a date field in a
table that is in an external database?

Thanks for your help... Rod

 

[TC]

Or, read the other respondent, who has the right answer!

(oops)
TC

 

[Tim Ferguson]

(oops)
TC

<g>



Tim F