Update Problem

I faced some problem in data updating, use connectionstring Microsoft.Jet.OLEDB.3.51;


Run-time error '-2147217900(80040e14)':
Syntax error(missing operator) in query expression '"12300" Lstate="Pahang'"


here is my coding:
Set rst = New adodb.Recordset
rst.Open "Lecturer", db, adOpenDynamic, adLockOptimistic

db.Execute "UPDATE anggota set LName=""" & LecName.Text & """," & _
"LAddress=""" & txtLecAdd.Text & """," & _
"LCIty=""" & txtCity.Text & """," & _
"LPostCode=""" & txtPCode.Text & """ " & _
"LState=""" & cboState.Text & """," & _
"LTel=""" & txtLecTel.Text & """," & _
"LRoom=""" & txtRoom.Text & """ " & _
"LEmail=""" & txtEmail.Text & """ " & _
" WHERE LID=""" & txtLecID.Text & """"

Please advise me what is the problem actually??
Thanks in advanced....!

Hello Shanny,

You are missing some commas. Try this:

db.Execute "UPDATE anggota set LName='" & LecName.Text & "'," & _
"LAddress='" & txtLecAdd.Text & "'," & _
"LCIty='" & txtCity.Text & "'," & _
"LPostCode='" & txtPCode.Text & "'," & _
"LState='" & cboState.Text & "'," & _
"LTel='" & txtLecTel.Text & "'," & _
"LRoom='" & txtRoom.Text & "'," & _
"LEmail='" & txtEmail.Text & "'" & _
" WHERE LID='" & txtLecID.Text & "';"

It is work....!! Thanks a lot ... Thanks JamesLe