I suggest you ...

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.

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    John Ford shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Planned  ·  AdminAccess Team (Admin, Microsoft) responded  · 

    We are designing on a new Linked Table Manager dialog, incorporating suggestions and requests made in UserVoice and other forums.

    Stay tuned.

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base