I have trouble with this query:
UPDATE Table1 IN '' ';Database=C:\data.mdb;PWD=xyz' AS T1
INNER JOIN Table2
ON T1.ID=Table2.ID
SET T1.Field1=Table2.Field2
WHERE Table2.Field3='something'
I have this error message ,,Syntax error in UPDATE statement,,
Thanks for your help.