
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. I was doing the delete =
but wasn't refreshing the DB afterwards so the link to the table kept =
{*filter*} around. <br><br>Kim Crompton <<font =
color=3D"#000000">> wrote in article <<font =
color=3D"#000000">>...<br>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?<br><br>Kim<br><br>Jim Ferguson <<font =
color=3D"#000000">> wrote in article <<font =
color=3D"#000000">>...<br>> Kim,<br>> <br>> >Does anyone =
know how to join two MS Access tables from two different MS<br>> =
>Access databases that are located within the same subdirectory =
(without<br>> >using DAO)? Is this possible?<br>> =
<br>> The simplest way is to ATTACH to the tables in one database =
from the<br>> other. That way you can treat all the tables as if they =
were in the<br>> same database.<br>> <br>> You can dynamically =
create attachments at run-time if you need to.<br>> <br>> Another =
more cumbersome way is to use the 'in' clause of a SQL<br>> statement =
to specify the database containing the table. (This is not<br>> the =
same 'in' clause used to select from multiple values in a list.)<br>> =
See the SQL reference for details.<br>> <br>> <br>> -- Jim =
Ferguson, FMS<br>> <font =
color=3D"#0000FF"><u> http://www.*-*-*.com/ </u><font =
color=3D"#000000"><br>> <br><br></p>
</font></font></font></font></font></font></font></font></font></font></f=
ont></body></html>
------=_NextPart_000_01BC2410.A9749DC0--