Access操作多个SQL数据库

strCn = "[ODBC;Driver=SQL Server;UID=sa;PWD=qwe;Server=127.0.0.1;DataBase=Y]"
sql = "select a,b,c from " & strCn & ".T1 a " _
 & " left join " & strCn & ".T2 b on a.id=b.id"
如果T2在数据库X中，那么该怎么写查询呢？ .

sql = "select a,b,c from " & strCn & ".T1 a " _
  & " left join " & [ODBC;Driver=SQL Server;UID=sa;PWD=qwe;Server=127.0.0.1;DataBase=X].T2 b on a.id=b.id"