setting field default value through code (ADO vs DAO?)

R

rocco

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top