Date is a reserved word, try using
"INSERT INTO Training ( course , name , [date])";
Also if ldDate is a date type in VFP you should convert to character to be able to concatenate. (Of course it would be giving a different error message)
HTH
>I need some help on the following :
>
>I have been trying to insert a record to an Access database. I get an error when I try to insert it to a date field in the Access database.
>Here is the code :
>
>******************************************************************
>lcCourse = CourseList.Name && Get the name from CourseList cursor
>lcEmployeeName = EmployeeList.Name && get the employee form EmployeeList cursor
>
>ldDate = DTOC(Thisform.txtTrainingDate.Value)
>
>lcMDBStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=l:\ehs\data\eh&s.mdb;"
>oCn = Create("adodb.Connection")
>oCn.Open(lcMDBStr)
>oCn.Execute("INSERT INTO Training ( course , name , date );
> Values ( " + "'" + lcCourse + "' , ;
> " + "'" + lcEmployeeName + "' , ;
> " + "'" + ldDate + "' ) ")
>
>*******************************************************************
>
>I get the following error :
>
>OLE IDispatch exeption code 0 from Microsoft Jet database Engine:
>Syntax error in INSERT INTO statement...
>
>Any help would be appreciated.
>
>Thanks,
>Sergio