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