Open two access databases simultaneoulsy

  • Thread starter Thread starter samah
  • Start date Start date
S

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
 
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
..
 
John said:
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'
Click to expand...

Great, thank you John.

- samah
 
Back
Top