Open two access databases simultaneoulsy

[samah]

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

 

[John Spencer]

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'

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

 

[samah]

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'

Great, thank you John.

- samah