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.

Pete