When I try to update a record, I get the following error after clicking the 'update current record' button.

Error # = 80040E14
Description = [Microsoft][ODBC Microsoft Access Driver] Syntax error in date in query expression '# = 1'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 37000
NativeError = -3100

Here's the relevant asp file...

MyDb.DbMode="dual"
MyDb.DbGridInc = "5"
MyDb.DbSQL = "Select * FROM job_info_by_division" MyDb.DbNavigationItem="filter,top,prev,next,bo ttom,download,color,reload,update, add"

MyDb.DbNavigationIcon="std"

Mydb.dbEditDropFlds = "Jobtype,,,ENGINEERING/MOD/OTHER"
Mydb.dbEditFlds = "JobType, Tour,last, first, Mail Code, Division Name, Contact, Job Info"
Mydb.dbEditParams = "TableName=job_info_by_division,BookMarkFlds=0 ,TableTag=Border=2,InputSize=10x80"

MyDb.dbFilterParams = "TableTag=Border=2,, ApplyButtonText=Apply Filter, DropButtonText=None,, "
MyDb.DbFilterDropFlds = "JobType,,job_info_by_division,JobType,,,NoBla nk,,DISTINCT"
MyDb.DbFilterFlds="JobType,style=simple"

MyDb.dbGridDisplayFlds="JobType,Tour,Last,Firs t, Mail Code, Division Name, Contact"
MyDb.dbFormDisplayFlds="-1"

MyDb.DbFormMemo="10x80,Job Info"
MyDb.aspDBpro