Re: Multiple Access database connections

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

Date: Mon, 27 Sep 2004 05:57:02 -0700

Thanks, Andrew. It was kind of a sample question, in that I have to go
through a series of databases to perform the task at hand. I didn't want to
set up a link for all the databases, so I'll try the dataset solution.
Bill W.

"Andrew" wrote:

> "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
>
>
>

Relevant Pages

  • Re: Located databases no longer used.
    ... particular dband see if anything accesses them. ... Andrew J. Kelly SQL MVP ... > I'm looking to locate databases that have not been written to or accessed ... Is there a system table or stored procedure ...
    (microsoft.public.sqlserver.tools)
  • Re: database maintenance for companies that run 24/7
    ... Ken and Andrew, ... Isn't there fragmentation that also happens to the data on the ... Dan ... >> Do they have two databases and they switch back and forth? ...
    (microsoft.public.sqlserver.server)
  • Re: Moving SQL
    ... I have succesfully moved all the databases (including Sharepoint) on various ... Extra info for moving system databases at ... "Andrew CC" wrote: ...
    (microsoft.public.windows.server.sbs)
  • Re: Enterprise Manager for shared server
    ... databases will make it somewhat slow. ... Andrew J. Kelly SQL MVP ... >> Sounds like the databases may have Auto Close turned on. ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Using ADO recordset in a query
    ... I am trying to create the recordsets from the ... If I open the sql statement without the INSERT INTO, ... > But maybe you can use the IN clause in your append query to identify ... > the databases where your source tables reside. ...
    (microsoft.public.access.modulesdaovba)