Linking tables to two back ends

Hello, I was wondering if something was possible in access. I have inherited a database that has multiple back ends. All back ends feed into another database where the pooled information is collected. What I would like to do is have two tables. One where the back locations are set Example:

Pittsburgh \\steel\database\PittBE.mdb
Canada \\leaf\database\CanBE.mdb

One with the linked table names that will need to be linked. Example:

tblCategories
tblSubcategories

I want the user to be able to select on a combo box, their location and update the links to the appropriate location. However I want to have some of the tables in the front end to be linked to the pooled database. These would be tblProjects, tblAssociates, tblPositions

any help would be appreciated, or maybe there is a better way to do this then the one I have proposed.

Thanks

I would use this:

ReLinker: multi-BE, Label Table Description to show Connect info

Works great!