>Eric,
>
>Is it possible to do the join in code rather than linking the tables in the database? I am using ADO and have tables in multiple databases. At the moment I am opening multiple recordsets and using a filter, but know it would be much faster to create one recordset with a join. Just now the database is Access, but (hopefully) will change to SQL Server or Oracle soon.

Join is a database operation. ADO is not offering any way of doing it.