Simple question about ADO

[Lucky]

How do I set up table fields (such as Caption, Default
Value, Required, etc.) with ADO? I need to recreate a
table using ADO that is later deleted.

I have spent days searching for an answer with no luck.
Any help or resource is greatly appreciated.

Thank you.

Lucky

 

[Dev Ashish]

How do I set up table fields (such as Caption, Default
Value, Required, etc.) with ADO?

Take a look at

[ http://support.microsoft.com/default.aspx?scid=kb;en-us;275252 ]

While it doesn't list all properties (and not all may be available if
you're going against SQL in an ADP), you should be able to use the syntax
provided in the KB article.

-- Dev