Setting Columns to allow Zero Length Strings in Access

[powahusr]

I need a way to set columns in an Access table to allow zero length strings. The database is on a Web server, so I'm going to have to update the table by running an ASP page with ADO code included in it. I'm kind of a novice with ASP and ADO, so I was wondering if someone could help me out?

Thanks in Advance!!!

 

[cmmrfrds]

Whether the column allows zero length is part of a text columns property in the Access table. Can you not just review the table definitions and see if it is set or are you asking something else. Zero length could also be the default for the column in the table.

 

[powahusr]

I cannot view the Table Definitions since I only have FTP access to the database.

When a table is created in Access, whether by SQL or the Access GUI, by default the column property "Allow Zero Length String" is set to NO. Since I can only ftp into my web server out on the net, I will need to find a way to set the property to "YES" without going into the database itself.

If the particular Field is not a required field in my form, I don't want an error to occur everytime a visitor submits the form when a value for that particular field is left blank. I cannot download the database to update the field for obvious reasons. I think that the only way to do it, is by doing it via ASP/ADO.

 

[cmmrfrds]

Check out this link. It has some code examples and what you need looks like it is covered.

http://www.gab2001uk.com/visualbasic/sampledatabase/

 

[powahusr]

Thanks for you post cmmrfrds, but I think that article is geared towards using Visual Basic.