RE: Newbie Q- Set Required Property

From: Armond (Armond_at_discussions.microsoft.com)
Date: 12/30/04


Date: Thu, 30 Dec 2004 10:07:04 -0800


"Dave@LAD" wrote:

> Sorry if this is a basic question, I'm new to ADO.
> I'm using ADOX with MS Jet4.0 and VB6 to create a MDB (Access) file, Table
> and Columns (fields).
> My problem/question:
> All fields are set to Required=Yes but this does not fit my data model -
> which only requires the key field.
> How do I set the Required property for the Table/Field(s)- any sample code
> for this?
>
> Various KB articles discuss the Required Property, how to set using GUI and
> that it can be done using VB but I can find no example/instruction.
>
> Any help/comments welcome & Thanks in advance.
>
> DaveAtLadenterprizesDotCom
>
>