create a query over 2 databases

[NeilPattison]

Hi all,

Is it possible to create a query that looks over two different databases for information. i.e I have two departments at work that have seperate databases and I need to be able to search for data in both of them on the same query.

Any help would be greatly appreciated.

 

[dhookom]

You can link to the tables from each database and then create a union query from the two tables.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Remou]

You can use:
In "C:\Path\Database"

For example:
[tt]SELECT tblA.ID, tblB.ID
FROM tblA INNER JOIN tblB ON tblA.ID = tblB.ID IN 'C:\Docs\Tek-Tips.mdb';[/tt]