Linking two Databases on different servers

[sahaitu]

Can anyone offer any suggestions as to how I would link two databases on two servers.

Scenario:

I have a legal database that captures issues for different member associations.

There is another database that captures issues for the same associations, though there DB will be installed on a different server.

How will I link a form in the Legal database to the form and tables in the other DB?

Thanks

 

[OnTheFly]

Through Access you should be able to link to the tables from both sources in one database. As for linking forms, I am not sure what you are refering to there. Once the tables are link ed you should be able to bind the forms to those tables or queries created from those tables.

Hope this helps.

OnTheFly