UPDATE query using INNER JOIN across multiple databases

[LuboG]

I have trouble with this query:

UPDATE Table1 IN '' ';Database=C:\datanew.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,,.
Can you anybody tell me what is wrong?

Thanks for your help.

[June7]

Never seen that syntax. Where did you find it? Your db sits at the C: root? I found a reference that shows this syntax for referencing the external db http://www.tek-tips.com/viewthread.cfm?qid=1223940:

[;Database=C:\datanew.mdb;PWD=xyz].Table1 AS T1

[LuboG]

Thanks Super Moderator,

I don't use root directory for my database, it was only simple sample.
My syntax SELECT * FROM Table1 IN '' ';Database=C:\datanew.mdb;PWD=xyz'
working corectly my c++ Builder ADO component and in MS Access 2010.
Your synatax SELECT * FROM [;Database=C:\datanew.mdb;PWD=xyz].Table1
working corectly only in MS Access 2010 but in C++ Builder 6 or RAD studio XE3
i have this error:
,,Parameter object is improperly defined. Inconsistent or Incomplete information was provided.,,
World is too complicated...

[LuboG]

...it's corect solution with quotes for all (C++ Builder and Access 2010)

UPDATE [';Database=C:\data.mdb;PWD=xyz'].Table1 AS T1 ...