| | |
|
|
|
ADO OLEDB Jet Property ADOX "Required" |
|---|
| message from George Hester on 30 May 2004 |
I have made a table with Properties using the Catalog Object from ADOX. =
tblLoadOLE.Columns("OLEFile").Properties("Required") =3D "No"
But that doesn't work. The error is:
ADODB.Properties error '800a0cc1'=20
Item cannot be found in the collection corresponding to the requested =
name or ordinal.=20
Any suggestions how to set the "Required" Property to "No?" Thanks.
|
| Dirk Goldgar replied to George Hester on 30 May 2004 |
"George Hester" <hesterloli@hotmail.com> wrote in message
news:ejAW3LgREHA.1312@TK2MSFTNGP12.phx.gbl
I've never worked with ADOX, but a quick look at the help file suggests
that you want this:
With tblLoadOLE.Columns("OLEFile")
.Attributes = .Attributes Or adColNullable
End With
Let me know if that works.
|
| George Hester replied to Dirk Goldgar on 30 May 2004 |
Well I probably should have just tried the obvious. I thought since =
this was a field of an OLE Object that the Property of the field would =
be different. I did find that there was some sort of bug on this =
located here:
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;185823
but that really wasn't exactly my issue. At least I don't think so. It =
turns out for other fields a text one for example I am able to Require =
it to be non-nullable by doing this:
tblLoadOLE.Columns("OLEPath").Properties("Nullable") =3D False
As you can tell OLEPath the value that should be in this field is text =
(255) and the above makes that field (OLEPath) not accept nothing. So I =
should have just tried this:
tblLoadOLE.Columns("OLEFile").Properties("Nullable") =3D True and =
OLEFile is a OLE Object field.
Well there you go. The OLEFile field now says, Not Required =3D "Yes" =
Hmmm...seems obvious don't it? Sorry for the inconvience but thank you =
for responding.
|
|
Archived message: ADO OLEDB Jet Property ADOX "Required" (MS Access)
