General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Inserting to an Access database
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only