Create linked tables

Results 1 to 2 of 2

Thread: Create linked tables

  1. #1
    Join Date
    Dec 1969

    Default Create linked tables

    Is there a way to create linked tables in Access mdb file from tables in another mdb file using ADO?

  2. #2
    Join Date
    Dec 1969

    Default RE: Create linked tables

    If you truly need &#039;linked&#039; tables I can&#039;t answer that. But if you are interested in just JOINing tables in different Access DBs you can use the IN operator and a full path to the other DB.<BR><BR>Sorry, I don&#039;t have the exact syntax in front of me, but it&#039;s close to:<BR><BR>SELECT Foo, Bar <BR>FROM myTable1<BR>INNER JOIN myTable2 IN &#039;C:folderfolderDateBase2.myTable2.mdb&#039;<B R>On myTable1.Foo = myTable2.Foo<BR><BR>And use a conn to the 1st table.

Posting Permissions

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