Simultaneously pulling data from multiple databases

[Guest]

I've got 2 databases. Each with a variety of tables. Fortunately, all of
the tables contain a Project Number field with the same format.

In database 1, the tables have a Project Number that is distinct to each
record; so the primary key is usually the Project Number. In database 2, the
Project Number is oftentimes duplicated and many of the tables currently have
no primary key.

I need to run a report that pulls data from both databases at the same time.
Do I need to create any relationships among the tables that I will use? If
so, how? Secondly, how do I create this report to read from multiple
databases at once?

 

[Guest]

In a nutshell:
The first thing to do is create links to the tables in both databases.
Secondly, create the query that fetches the data you need for your report.
Then, create the report and base it on your new query.

Are the two databases Access databases?

Ray

 

[Guest]

Yes, both are access databases.

 

[Guest]

How do I link the table from one database to the table in the other database?

 

[Douglas J. Steele]

File | Get External Data | Link Tables on the menu bar.

 

[aaron.kempf]

if you were using Access Data Projects; it would be super-easy to join
between 2 different databases.

using Access MDB there are about 20 steps that are confusing and
difficult

-Aaron