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

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

(oops)
TC

"TC" <(E-Mail Removed)> wrote in message news:1059974332.721198@teuthos...
> I *think* (but I don't have Access here to check) that the default value
of
> a field is implemented as (snip)

"TC" <(E-Mail Removed)> wrote in news:1059974419.218062@teuthos:

>
> (oops)
> TC
>

<g>



Tim F