Re: DefinedSize in ADOX

Bob Barrows [MVP] wrote:

- Setting the "Allow Zero Length" (can't seem to do with DDL/Access).

Actually, it can: you have to use the provider-specific properties

(http://msdn.microsoft.com/library/en-us/oledb/htm/oledbprovjet_appendix
_a_properties.asp):

DBPROP_JETOLEDB_COL_ALLOWZEROLENGTH

Oops, I've been having some reading comprehension problems lately. You
are correct, this is an Access-defined property which is not accessible
to JetSQL DDL.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages