Hi<BR>Can anyone tell me what the correct syntax is for setting &#039;allow zero length&#039; to yes using the ALTER TABLE SQL statement? I am using ASP (Vbscript) and Access 2000. I can use null/not null but this does not alter the zero length setting. I currently have to download the database, apply the new setting and then re-upload it which is not ideal.<BR><BR>All help would be appreciated.<BR>Thanks