ADOX - creating tables

[Lenny]

I am creating a new Access database using code in VB6 with ADOX. There
doesn't seem to be an awful lot of info available on this subject. I have
found some useful tips on this newsgroup.
When creating a new column, how do I go about setting the various properties
of the column, I've seen some examples of statements such as:
objNewColumn.Properties("Default").Value = "Test"
(Which by the way I can't get to work.) What I would like to know is where
can I find a list of the properties that can be set for a column.

Thanks.

[Lenny]

May have answered my own question. Took a look at the ADOX stuff in the
object browser. But if anyone has any other info let me know!

Lenny <biscuit@springmail.com> wrote in message
news:38d6d6e4@news.devx.com...
> I am creating a new Access database using code in VB6 with ADOX. There
> doesn't seem to be an awful lot of info available on this subject. I have
> found some useful tips on this newsgroup.
> When creating a new column, how do I go about setting the various
properties
> of the column, I've seen some examples of statements such as:
> objNewColumn.Properties("Default").Value = "Test"
> (Which by the way I can't get to work.) What I would like to know is where
> can I find a list of the properties that can be set for a column.
>
> Thanks.
>
>
>

[Paul Clement]

On Mon, 20 Mar 2000 21:08:02 -0500, "Lenny" <biscuit@springmail.com> wrote:

¤ I am creating a new Access database using code in VB6 with ADOX. There
¤ doesn't seem to be an awful lot of info available on this subject. I have
¤ found some useful tips on this newsgroup.
¤ When creating a new column, how do I go about setting the various properties
¤ of the column, I've seen some examples of statements such as:
¤ objNewColumn.Properties("Default").Value = "Test"
¤ (Which by the way I can't get to work.) What I would like to know is where
¤ can I find a list of the properties that can be set for a column.

Here is doc on the Column object with associated links:

http://msdn.microsoft.com/library/ps...k/adod9goe.htm


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)