>I need to access tables from two different databases (MDB's) in a single ADO >query. > >Is this possible and what should the SQL statement look like?
Since you mention MDB, I assume you are using MS Access. There is no shortage of things to criticize about MS Access, but one thing I do like about it is the ease with which you can build a "federated" database. A federated database allows you to tie together multiple databases and perform queries that join tables from the databases. The way MS Access does this is that you create a "linked table". This table can then be used just as you would a regular Access table. Linked tables can be other MDB files, or any other database with an ODBC driver. HTH, Glenn Lawler www.incodesystems.com
