Hello all,

I'm making a schedule page where different users(volunteers) login and add time to the schedule everything works great except when I try to insert a record. This is the error I get along with the SQL statement. I'm using Access 2000 and Ultradev 4. All of the columns are using text format and all the code was written by UD4.
<b><pre id=code><font face=courier size=2 id=code>
insert into vtimes (date,start_time,end_time,volunteer) values ('5/16/2002','5:00:00','6:00:00','Volunteer_1')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/sNs2/staff/inserttime.asp, line 130
</font id=code></pre id=code></b>

Any help will be greatly appreciated this is due by the end of may!

Date is a reserved word, try changing the field name in the database to something else e.g. volunteer_date

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo