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. Why then would it be a problem that
I'm passing an empty var to use for Volunteers.Email??

Any input would be great. Thanks!
        Nick

Reply via email to