Improved Table Manager
Create an enhanced table manager that allows users to specify data source (sql, access, txt etc), source table name, attached name, any passwords (encrypted or hidden) and primary keys so that the system will drop existing links and refresh as needed. You would need a couple of tables for data sources and data source tables but many developers have done this over the years and lots of examples that could be incorporated. This is used all the time.
We are designing on a new Linked Table Manager dialog, incorporating suggestions and requests made in UserVoice and other forums.
An Access MVP (Tom V) is working on an LTM on steroids that solves a lot of the issues with the current LTM. It's currently in beta testing and hopefully will be for sale in the near future.