Is this possible via ADO?  I have two connections, one to an Access database
and another to an AS/400 database.  I can get a recordset from a table in
each of these separately, but then I want to do a query that would be a SQL
join between these two recordsets.   I know I could to this by using an ODBC
linked table to the AS/400 in Access first, but that introduces a lot of
overhead and slowness for ODBC.  Is there any way to do this purely with
just ADO?

I found this tantalizing post on deja.com that indicates this might be
possible, assuming the guy new what he was talking about:

http://www.*-*-*.com/

Thanks

ADO can't perform joins against heterogeneous data sources in the way you
mentioned.  You need a database engine with a query optimizer such as JET or
SQL Server to perform the join.

My $0.02
--
Patrick Logan, MCSD
Senior Technical Development Advisor
McKessonHBOC -- Extended Care Solutions Group

Opinions expressed are my own and not necessarily those of McKessonHBOC.

Thanks.  I suspected it had to be a database engine feature but I wasn't
totally sure.