syntax error in UPDATE statement

M

Makelei

Hi,
Using Access 2003 and XP.

What could be the reason that in some computers my SQL UPDATE works fine and
in some it gives warning "syntax error in UPDATE statement" and does not
update table as it shoud?

BR
Makelei
 
P

Paolo

Hi Makelei,

it could be some differences in the regional settings i.e. decimal symbol,
list separator etc.

HTH Paolo
 
M

Makelei

Hi,
Thanks Paolo. Solution was , needs to be set to . in regional settings.

BR
Markku
 
Top