Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting Columns to allow Zero Length Strings in Access

Status
Not open for further replies.

powahusr

Technical User
Jan 22, 2001
240
US
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!!!
 
Do you mean NULL? Recommend you use if you don't, much better practice to insert NULLS than empty strings. If so just make sure that, in design view, the field is not 'Required'
 
Yes, I think thats the only way get around it. Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top