Multiple Access database connections

From: Bill Wanschura (BillWanschura_at_discussions.microsoft.com)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 09:02:09 -0700

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?

Bill W.

Relevant Pages

  • Re: Multiple Access database connections
    ... > I'm new to ADO and I think I'm missing something. ... > My master table (tblMaster) on databaseA has a stateCode field that is ... > on my refStateName table on databaseB. ...
    (microsoft.public.data.ado)
  • RE: Multiple Access database connections
    ... Since, you have the tables in two seperate databases, create a dataset ... If there is only 1 StateCode per state, ... > My master table on databaseA has a stateCode field that is also ... > on my refStateName table on databaseB. ...
    (microsoft.public.data.ado)
  • Re: Ancestry - UK Births/1951/Quarter 3
    ... researchers in the future looking for that missing page. ... My experience of Ancestry is that they have no interest in correcting their ... Ancestry seems to work to the model of 'cram as many databases in as ...
    (soc.genealogy.britain)
  • Re: Intellisense not working properly
    ... I can manually enter any missing attribute (such as "Document" ... neither of which shows in intellisense) and they work fine ... > Doug Steele, Microsoft Access MVP ... >> functional in any of my Access 2003 databases or projects. ...
    (microsoft.public.access.formscoding)
  • Re: Missing reference to OWC10.DLL - how to fix?
    ... NOTE the exact name of the missing item. ... UNCHECK it. ... If you do get errors, then open Tools, references. ... I checked some of my other databases and they were correctly ...
    (microsoft.public.access.modulesdaovba)