Re: Multiple Access database connections

From: Andrew (abaylis_nos_at_spamcop.net)
Date: 09/25/04

  • Next message: William \(Bill\) Vaughn: "Re: exception error when accessing SQL database" 
    Date: Sun, 26 Sep 2004 09:57:20 +1000

    "Bill Wanschura" <BillWanschura@discussions.microsoft.com> wrote in message
    news:F6F97B62-D28C-432B-AA65-E2431F812B84@microsoft.com...
    > I'm new to ADO and I think I'm missing something. I need to connect to
    > two
    > different tables on two different Access databases. I have been able to
    > get
    > the connections and recordsets set up so I can list the rows in each
    > table.
    >
    > How do I set up a query using the two tables to cerate another recordset?
    > I
    > am so used to Tabledefs and Querydefs that I am not understanding the
    > object
    > model of Commands and Recordsets.
    >
    > My master table (tblMaster) on databaseA has a stateCode field that is
    > also
    > on my refStateName table on databaseB. I want to JOIN tblMaster and
    > refStateName on stateCode and list the stateCode field from tblMaster and
    > the stateName field from refStateName.
    >
    > What am I missing here?
    >
    Why not create a linked table in one of the datasets pointing to the table
    in the other dataset? Then you can execute a query that joins the two tables
    quite easily.
    Andrew

  • Next message: William \(Bill\) Vaughn: "Re: exception error when accessing SQL database"