go to database utilities|Linked Tables. It's only
available if you installed "Advanced wizards" during
setup (Access2000 and above).
Dave
--- "Glenn B. Lawler" <[EMAIL PROTECTED]>
wrote:
> >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
>
>
____________________________________________________________________________________Pinpoint
customers who are looking for what you sell.
http://searchmarketing.yahoo.com/
