allow zero length strings

 

if you create a form for data entry and send it off leaving one or more fields empty you might get an error like the following:

 

 

Microsoft OLE DB Provider for ODBC Drivers error '80004005'.

[Microsoft][ODBC Microsoft Access Driver]Field '...' cannot be a zero-length string.

 

 

 

there is nothing wrong with what you have done in Ultradev but with the way you created the database.

to remedy this for an Access database open the database, open the table concerned in design view, select the field you want to change and check the general properties at the bottom. there is an option called "Allow Zero Lenght". this must be set to "yes".

 


 

1