Alter Table Query to Change Accept Zero Length Property ?

D

DCCNET.NEWS

I need to set the Allow Zero Length property of a column to true
programmatically.
Is there a way to use an ALTER TABLE query to modify an existing column's
Allow Zero Length Property?
Or any other way using an ADO connection from VB6? This would be for Access
2000 and/or 2002.
 
A

Allen Browne

No. You can set the Allow Zero Length property only through the DAO or ADOX
libraries.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending zero-length string 4
Programmatically changing table property 6
How to Change criteria on a saved query using VBA 0
how to control "allow zero-length" property with alter statements 2
Allow Zero length property not working when using create table sql statement 2
Convert zero-length string or blank cell to null 3
ALTER TABLE query - "Allow zero length" 2
Allow Zero Length String Property - 2000 vs 2003 5

Top