Linking Tables how to simplify

[Ste4en]

I have an Analysis_Database which reads tables and performs calculations in a Project_Database. There are multiple Project_Databases which reside together in a folder. To run my queries and analysis I link my Analysis_Database to each of the other databases and run my reports.

Is there a way to set up these links in a table or something to eliminate the Tools/Utilities/Linked Table Manager...etc

Any siuggestions to make this process more streamlined would be appreciated. (I can not make any changes to the Project_Database).



Thanks

 

[neileg]

Why not link to all the Project Databases at the same time? Is there a reason why you have to drop the links?