How to link tables from two databases

Results 1 to 2 of 2

Thread: How to link tables from two databases

  1. #1
    Allen Chen Guest

    Default How to link tables from two databases

    I have two MS Access database files, "a.mdb" and "b.mdb". How can I link tables from both datbases like:<BR>"SELECT * from Database1.Table1 JOIN Database2.Table2 WHERE Table1.ID = Table2.ID" ? <BR><BR>I know that in Visual Basic you can query through multiple files by using syntax like:<BR>"SELECT * FROM &#039c:datadb1.mdb&#039.table1 JOIN &#039c:datadb2.mdb&#039.table2 ...."<BR><BR>Thank you very much,<BR><BR>Allen Chen<BR>allen@allenchen.com

  2. #2
    Michael Bird Guest

    Default RE: How to link tables from two databases

    This may be a simplistic answer but in my case i simply linked the tables in Access in one database from the other. You then simply refer to it as a normal table in database B. I am curious to a real answer to your question too, but that got me through.<BR><BR>Michael Bird,<BR>mbird@spindustry.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •