RE: Query from multiple databases

>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

Messages in this topic (0) Reply (via web post) | Start a new topic

.

go to database utilities|Linked Tables. It's only
available if you installed "Advanced wizards" during
setup (Access2000 and above).

Dave

--- "Glenn B. Lawler&quot; < gblawler%40incodesystems.com">gblawlerincodesystems.com&gt;
wrote:

> >I need to access tables from two different
> databases (MDB's) in a single ADO query.
&gt; >
>; >Is this possible and what should the SQL statement
> look like?
&gt;
> 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
&gt; does this
>; is that you create a "linked table";. This table can
> then be used
>; just as you would a regular Access table. Linked
&gt; tables can
> be other MDB files, or any other database with an
> ODBC driver.
>
> HTH,
>;
> Glenn Lawler
&gt; www.incodesystems.com
>
>

__________________________________________________________Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/

Messages in this topic (0) Reply (via web post) | Start a new topic

.