Hey

this is probably a really stupid question, and i know ive probably missed somthing really simple, im using an insert record server behavior to insert data from a form into a database, but i want to make it so that the user doesent HAVE TO fill in all of the fields, they can leave them blank for example. there are also file fields in the form, because im uploading a file with pureASPupload, which i also want to be an optional field. The problem is that when i press the submit button after not filling in all of the fields, i just get this error message:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/register.asp, line 116

Can somone tell me how to fix this???

Fistly, open the database table, into which you are trying to insert the record, in design view and check that the Field Property - Required is set to <b>No</b>

Secondly I seem to remember having a problem with pureASPupload where it would not let you leave the field blank.

Try it without pureASPupload first, once everything else is working add pureASPupload and check it's still OK.


Regards

Owen.