UPDATE query using INNER JOIN across multiple databases

[LuboG]

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.

 

[LuboG]

...or this sample:
UPDATE [;Database=C:\data.mdb;PWD=xyz].Table1 AS T1
INNER JOIN Table2
ON T1.ID=Table2.ID
SET T1.Field1=Table2.Field2
WHERE Table2.Field3='something'
working corectly only in MS Access 2010, but in my C++ Builder 6 or RAD Studio XE3 I have this error (I use ADO componets):
,,Parameter object is improperly defined. Inconsistent or Incomplete information was provided.,,