Jul 08 2020 11:04 AM
Hello,
I can´t seem to delete links in the Linked Tables Manager - Microsoft Access.
A couple of weeks ago, I would change the links by deleting the existing ones and adding a new when I needed to change from production environment to testing environment. Now, when I click Linked Tables Manager in my db, the option "delete" and "Add" are not available on screen. What changed? How can I delete and add a new access table to the links on my Access DB?
Jul 09 2020 06:17 AM - edited Jul 09 2020 06:18 AM
@tecmetro You didn't specify which version of Access you are using. So far as I know, the Linked Table Manager has not included an option to add or delete tables in any version up to Access 365.
The newest versions of Access 365, however, do include an enhanced Linked Table Manager.
Perhaps what happened here is that you WERE working with the newer Access 365 LTM, but happened to open this accdb with an older version.
Jul 13 2020 04:44 AM
Jul 13 2020 06:23 AM
Solution@tecmetro You can still change the links, just not via that enhanced LTM. And I am not at all clear on how you can have that 2013 version of Access with the enhanced LTM. I suspect there's a bit more to the story....
In any case, do this:
Jul 13 2020 07:26 AM
Jul 13 2020 07:39 AM
Jul 13 2020 06:23 AM
Solution@tecmetro You can still change the links, just not via that enhanced LTM. And I am not at all clear on how you can have that 2013 version of Access with the enhanced LTM. I suspect there's a bit more to the story....
In any case, do this: