On Tue, 30 Jul 2002 15:16:18 -0400, Nick Hoffman [UWO] wrote:
>I'm trying to insert into a table where only 3 fields (1 being the primary
>key) are required, yet I get the following error when I execute:
>
>---------------
>Died while executing:
>[Microsoft][ODBC Microsoft Access Driver] Field 'Volunteers.Email' cannot be
>a zero-length string. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)
>---------------
>
>However, when I look at the design view of the table Volunteers (Access2000
>DB), the Email field is not required.
To Access, there is a difference between a zero length string, and a
NULL. The latter should be acceptable, according to what you say, while
the former isn't.
So: if you find a zero length string, replace it with undef. that should
be enough.
--
Bart.
