Open two access databases simultaneoulsy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

samah - 29 Jun 2007 07:25 GMT

Access newbie. Win Xp. Access 2003.

I need to open two tables side by side to compare them but the tables
reside in two different access databases. Is it possible to do it
without linking or importing one table into the other db.

TIA

- samah

Reply to this Message

John Spencer - 29 Jun 2007 12:45 GMT

You can trya query that uses the "in path" syntax that Access allows

Syntax is:
SELECT <FieldList>
FROM <TableName> In 'full path to file containing table'

Sample SQL
SELECT fldPK, fldTitle, fldDetails
FROM FAQ in 't:\Newsgroup Answers_2K3.mdb'

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Access newbie. Win Xp. Access 2003.
>
[quoted text clipped - 5 lines]
>
> - samah

Reply to this Message

samah - 29 Jun 2007 14:37 GMT

> You can trya query that uses the "in path" syntax that Access allows
>
[quoted text clipped - 5 lines]
> SELECT fldPK, fldTitle, fldDetails
> FROM FAQ in 't:\Newsgroup Answers_2K3.mdb'

Great, thank you John.

- samah

Reply to this Message