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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Set Values 3
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Update syntax for a remote table access 1
SQL statement 2
Error 3144 syntax error in UPDATE statement 5
Update Office (Outlook) 2007 on 13/09/2017 2
Syntax Error on UPDATE statment 2
Syntax error on Update 2

Top