UPDATE records using Database Conectivity toolset

[Simbani]

I´m using LabVIEW 8.5 & Database Connectivity toolset ver 1

When I try to update a record of a MS ACCESS 2003 with the SQL UPDATE TablenName SET field1=newvalue, field2=newvalue........WHERE condition=x, I get the error -2147217900 Exception occurred in Microsoft Jet DataBase engine: Sintax error in the instruction UPDATE.vi ComExec (8.5 bug Workaround)vi.

I ´dont think I have made a sintax error. If the field is an string I use the 'newvalue' following by a comma, in case of numeric field just the coma. For instance :

UPDATE TableName SET Name='John', Age=22,Hair='blond' WHERE height=1.85

I have discarded the reserved word´s problem, as I can insert records in the data base without any problem 

Any idea to solve the problem

Thanks

Simbani

[Odd_Modem]

Did you try it like this?

UPDATE TableName SET TableName.Name='John', TableName.Age=22,TableName.Hair='blond' WHERE TableName.height=1.85

[Simbani]

Thanks,

Í have tried as your suggested and although, I don´t get any error, the record is not modified.

Simbani