User Profile

Collapse

Profile Sidebar

Collapse
jypw
jypw
Last Activity: Jun 25 '10, 07:02 PM
Joined: Jun 25 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jypw
    started a topic How to select from 2 tables in 2 different accdb (Access) files.
    in Access

    How to select from 2 tables in 2 different accdb (Access) files.

    Hi!

    I have 2 accdb files. I need to create a recordset that will include rows comming from 2 tables that are in 2 different accdb file.

    Like:
    Code:
    select a.no, a.name, a.address, b.total
from table1 as a, table2 as b
where a.no = b.no
    Both table1 and table2 are stored in 2 different accdb files

    Is that possible? I will need 2 connections, and I can't see how I can "select" from...
    See more | Go to post
    Last edited by NeoPa; Jun 27 '10, 09:47 PM. Reason: Please use the [CODE] tags provided
    • jypw
      replied to ADODB.recordset with 2 databases
      in ASP Classic
      Access

      Hi!

      That is interesting. And what if I have two accdb(access database)?

      I have 2 accdb files. I need to create a recordset that will include a link to 2 tables that are in 2 different accdb file.

      Is that possible?

      Thanks
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...