I was able to do with with Access XP and Vantage 6.1. With 2 DSN's, 2 linked tables, 2 make Table Queries.
Brian
Brian
--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> Hi Todd,
>
> I happen to have a similar setup so it was easy for me to test this.
> I ran two queries against PartTran just now:
> 191050 records from test, 206450 from live.
>
> I wonder how yours are set up?
>
> I have MS-Access 2003, Vantage 8.03.4xx
> & two DSN's and two queries to make two tables.
>
> Bruce
>
> --- In vantage@yahoogroups.com, "Todd Gilbert" <tgilbert@> wrote:
> >
> > I'm trying to create two queries in Access that pull data from the
> > PartTran table of our live database and the PartTran table of our
> > Training database (populated with a backup of live data from a week
> > ago).
> >
> >
> >
> > It appears to lock into the last ODBC connection string used and only
> > brings in data from one database even if though each query contains the
> > unique connection string to each database.
> >
> >
> >
> > Any ideas ??
> >
> >
> >
> > Thanks and have a great weekend!
> >
> >
> >
> > Todd Gilbert
> >
> > GCM, Inc.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>