Hello,

I have the following query that is giving me error:

Microsoft JET Database Engine
-2147217900 Syntax error in UPDATE statement.

UPDATE Employees SET First_name = "Faaez", Last_name = "Kamaal", Middle = 'A', Address = "5835 S. Blucher Drive", City = "Tucson", State = 'AZ', Zip = '85746', Phone = '5207417099', Alt_phone = '5207410715', Type = 'S', User_id = 'FAAEZ', Password = '123456', Status = 'W', Commission_p = 50, Commission_f = 100, Commission_m = 250, DLN = 'D12345678', DL_state = 'AZ', DL_exp = '7/1/2006', SSN = '000000000', Notes = "This is a test.", Start_date = '7/1/2006', End_date = '7/1/2006', Salary_chk = 0, Comn_chk = 1, M_salary = 0 WHERE Emp_id = 1

I do not understand the error. Waisted half a day but enable to find any errors. When I paste this same thing in VISDATA it works just fine without errors but thru my application it is coming up with this error.

some dat has single quote arround it and some has double quotes. It is only because I am expecting an apostrophy s in that field. And ofcourse numbers are without any quotes arround them.

Any and all help will be greatly appreciated.