joining two tables from different dbs 
Author Message
 joining two tables from different dbs

Kim,

Quote:
>Does anyone know how to join two MS Access tables from two different MS
>Access databases that are located within the same subdirectory (without
>using DAO)?  Is this possible?

The simplest way is to ATTACH to the tables in one database from the
other. That way you can treat all the tables as if they were in the
same database.

You can dynamically create attachments at run-time if you need to.

Another more cumbersome way is to use the 'in' clause of a SQL
statement to specify the database containing the table. (This is not
the same 'in' clause used to select from multiple values in a list.)
See the SQL reference for details.

-- Jim Ferguson, FMS
    http://www.*-*-*.com/



Sun, 15 Aug 1999 03:00:00 GMT  
 joining two tables from different dbs

This is a multi-part message in MIME format.

------=_NextPart_000_01BC2408.B1ABDCE0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Thanks much for your suggestion.  I was able to create the table via a
tabledef.  Now my problem is I don't know how to delete it.  I can delete
the tabledef but it leaves the external table in my current database.  Any
suggestions?

Kim



Quote:
> Kim,

> >Does anyone know how to join two MS Access tables from two different MS
> >Access databases that are located within the same subdirectory (without
> >using DAO)?  Is this possible?

> The simplest way is to ATTACH to the tables in one database from the
> other. That way you can treat all the tables as if they were in the
> same database.

> You can dynamically create attachments at run-time if you need to.

> Another more cumbersome way is to use the 'in' clause of a SQL
> statement to specify the database containing the table. (This is not
> the same 'in' clause used to select from multiple values in a list.)
> See the SQL reference for details.

> -- Jim Ferguson, FMS
>    http://www.fmsinc.com

------=_NextPart_000_01BC2408.B1ABDCE0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head></head><BODY bgcolor=3D"#FFFFFF"><p><font size=3D2 =
color=3D"#000000" face=3D"Arial">Thanks much for your suggestion. =
&nbsp;I was able to create the table via a tabledef. &nbsp;Now my =
problem is I don't know how to delete it. &nbsp;I can delete the =
tabledef but it leaves the external table in my current database. =
&nbsp;Any suggestions?<br><br>Kim<br><br>Jim Ferguson &lt;<font =

color=3D"#000000">&gt; wrote in article &lt;<font =

color=3D"#000000">&gt;...<br>&gt; Kim,<br>&gt; <br>&gt; &gt;Does anyone =
know how to join two MS Access tables from two different MS<br>&gt; =
&gt;Access databases that are located within the same subdirectory =
(without<br>&gt; &gt;using DAO)? &nbsp;Is this possible?<br>&gt; =
<br>&gt; The simplest way is to ATTACH to the tables in one database =
from the<br>&gt; other. That way you can treat all the tables as if they =
were in the<br>&gt; same database.<br>&gt; <br>&gt; You can dynamically =
create attachments at run-time if you need to.<br>&gt; <br>&gt; Another =
more cumbersome way is to use the 'in' clause of a SQL<br>&gt; statement =
to specify the database containing the table. (This is not<br>&gt; the =
same 'in' clause used to select from multiple values in a list.)<br>&gt; =
See the SQL reference for details.<br>&gt; <br>&gt; <br>&gt; -- Jim =
Ferguson, FMS<br>&gt; &nbsp;&nbsp;&nbsp;<font =
color=3D"#0000FF"><u>http://www.fmsinc.com</u><font =
color=3D"#000000"><br>&gt; </p>
</font></font></font></font></font></font></font></body></html>
------=_NextPart_000_01BC2408.B1ABDCE0--



Sun, 15 Aug 1999 03:00:00 GMT  
 joining two tables from different dbs

This is a multi-part message in MIME format.

------=_NextPart_000_01BC2410.A9749DC0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Nevermind.  I was doing the delete but wasn't refreshing the DB afterwards
so the link to the table kept{*filter*} around.  



Thanks much for your suggestion.  I was able to create the table via a
tabledef.  Now my problem is I don't know how to delete it.  I can delete
the tabledef but it leaves the external table in my current database.  Any
suggestions?

Kim



Quote:
> Kim,

> >Does anyone know how to join two MS Access tables from two different MS
> >Access databases that are located within the same subdirectory (without
> >using DAO)?  Is this possible?

> The simplest way is to ATTACH to the tables in one database from the
> other. That way you can treat all the tables as if they were in the
> same database.

> You can dynamically create attachments at run-time if you need to.

> Another more cumbersome way is to use the 'in' clause of a SQL
> statement to specify the database containing the table. (This is not
> the same 'in' clause used to select from multiple values in a list.)
> See the SQL reference for details.

> -- Jim Ferguson, FMS
>     http://www.*-*-*.com/

------=_NextPart_000_01BC2410.A9749DC0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<html><head></head><BODY bgcolor=3D"#FFFFFF"><p><font size=3D2 =
color=3D"#000000" face=3D"Arial">Nevermind. &nbsp;I was doing the delete =
but wasn't refreshing the DB afterwards so the link to the table kept =
{*filter*} around. &nbsp;<br><br>Kim Crompton &lt;<font =

color=3D"#000000">&gt; wrote in article &lt;<font =

color=3D"#000000">&gt;...<br>Thanks much for your suggestion. &nbsp;I =
was able to create the table via a tabledef. &nbsp;Now my problem is I =
don't know how to delete it. &nbsp;I can delete the tabledef but it =
leaves the external table in my current database. &nbsp;Any =
suggestions?<br><br>Kim<br><br>Jim Ferguson &lt;<font =

color=3D"#000000">&gt; wrote in article &lt;<font =

color=3D"#000000">&gt;...<br>&gt; Kim,<br>&gt; <br>&gt; &gt;Does anyone =
know how to join two MS Access tables from two different MS<br>&gt; =
&gt;Access databases that are located within the same subdirectory =
(without<br>&gt; &gt;using DAO)? &nbsp;Is this possible?<br>&gt; =
<br>&gt; The simplest way is to ATTACH to the tables in one database =
from the<br>&gt; other. That way you can treat all the tables as if they =
were in the<br>&gt; same database.<br>&gt; <br>&gt; You can dynamically =
create attachments at run-time if you need to.<br>&gt; <br>&gt; Another =
more cumbersome way is to use the 'in' clause of a SQL<br>&gt; statement =
to specify the database containing the table. (This is not<br>&gt; the =
same 'in' clause used to select from multiple values in a list.)<br>&gt; =
See the SQL reference for details.<br>&gt; <br>&gt; <br>&gt; -- Jim =
Ferguson, FMS<br>&gt; &nbsp;&nbsp;&nbsp;<font =
color=3D"#0000FF"><u> http://www.*-*-*.com/ </u><font =
color=3D"#000000"><br>&gt; <br><br></p>
</font></font></font></font></font></font></font></font></font></font></f=
ont></body></html>
------=_NextPart_000_01BC2410.A9749DC0--



Sun, 15 Aug 1999 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Joining two tables from different dbs

2. Table join between two tables in different databases

3. Joining two tables from different databases

4. Creating a join on tables in two different MSSQL 6.5 DB's

5. Joining two tables on different length fields

6. Table join between two different databases (MSSQL 6.5)

7. Querying two recordset objects or Joining tables from different datastores

8. Join on two tables from different data sources?

9. Trying to bind data from two different tables to two different controls

10. Joining two tables from two databases

11. Here's a sticky wicket - joining two tables on two diffrent servers with ADO

12. Quering two tables in two different files

 

 
Powered by phpBB® Forum Software