REPOST: setting the field default value (ADO vs DAO?)

[rocco]

Sorry, I mistakenly posted this in the Query section ...I think this is the
correct section indeed.

Hello,
is there a wasy to set the default value for a field through code?
I have many tables - with lots and lots of fields - that were built without
assaigning a default value for the fields.
Since I would need to use SQL statement to populate may tables and since
there always be some blank field, i want to assign a default value to each
field so that at least the default value is stored into the table. I thought
that using code it would be easier to get ride of the hundreds of fields,
instead that going field by field and setting its default value property in
table design view.
I have fooled around with ADOX but I cannot find any properties for the
Column object to achive this goal. So maybe I was looking in the wrong place.
Maybe ADO?
Or should I stick with DAO?
Last: what's ADOR for?

Thank you!!
Rocco

 

[Douglas J. Steele]

Assuming you're talking about a Jet database (i.e.: an MDB), then I'd stick
with DAO.

See http://support.microsoft.com/?id=216389 for information about ADOR.

 

[rocco]

Thanks Doug, I will.

Assuming you're talking about a Jet database (i.e.: an MDB), then I'd stick
with DAO.

See http://support.microsoft.com/?id=216389 for information about ADOR.