Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Scottsdale, AZ
    Posts
    5

    Unanswered: Joining two ado recordsets

    I have two different ODBC datasources. I can create a recordset from both from an Access DB.

    Both have a field that has matching key data (partnumber in one database and pn in the other). The rest of the data is unique to the database I am pulling from...

    Basically:

    Connection1
    Recordset1 from connection1

    Connection2
    Recordset2 from connection2

    Once I have both RS created, is there a way to run a SQL Query using the two recordsets as though they were tables in a sql query so I can do a JOIN on the data.

    I need to create a list showing partnumbers in both and then part numbers that are "orphaned" in each.

    Thanks.

  2. #2
    Join Date
    May 2010
    Posts
    601
    Have you tried using linked tables?
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Yes. It would much easier to just link in both SQL Server tables into the mdb.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Nov 2002
    Location
    Scottsdale, AZ
    Posts
    5
    Problem is.. one of them is Mas 90 and linked tables, for whatever reason, seem to always prompt you for a password when you try to query them.. every time - even if you try to store that password when setting up the ODBC driver.

    But I will continue playing with it.

    Thanks.

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Are you selecting the "Save Password" checkbox when linking? (there's a small Save Password checkbox on the popup form where you select the tables to link.)
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Tags for this Thread

Posting Permissions

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