Linking two seperate databases

[Guest]

Is there a way to link two seperate databases? The reason for this is storage
capacity and different methodologies of collecting data but they are still
related in a general way.

 

[Joseph Meehan]

Is there a way to link two seperate databases? The reason for this is
storage capacity and different methodologies of collecting data but they
are still related in a general way.

You can link to tables in other databases. In general they will appear
and work like they are a part of the front end database (the one you are
in). Linking data in the remote database with the one in your database
would be very similar as linking the two tables if they were both in the
same database. They will need a common field.

Generally this is done because the two databases are maintained on
different machines. There are other options which may well be better,
depending on the situation.

 

[Joseph Meehan]

Indeed this is exactly what I was looking to do. My front end database
would need a common field with the other database which is on a different
computer. How would the process work if I were to do this?
thanks for your help.

Go to the "File" drop down menu and then select "Get external Data",
then select "Link Tables" Find the database containing the table and select
it, then select the table(s) you need.

After that they will appear on your tables list almost like they are a
part of the current database.

A lot of additional information will be available in Access if you press
F1 and search for linked tables.