Forum Discussion

yosimzl's avatar
yosimzl
Copper Contributor
Jul 07, 2020

When I use linked table manager to Reconnect tables VIEW-SQL the Key deleted -How to solve this pro

When I use linked table manager to Reconnect tables VIEW-SQL the Key deleted -How to solve this problem?? in ms access 2019 (365) hi When I use linked table manager to  Reconnect tables VIEW the  K...
access
office 365
  • yosimzl's avatar
    yosimzl
    Copper Contributor
    Jul 30, 2020

    Daniel_Pineault

    hi

    I was waiting for a new version
    And yet the problem is not solved

     

     

    • George_Hepworth's avatar
      George_Hepworth
      Silver Contributor
      Jul 31, 2020

      yosimzl 

      I have Access 2019 installed. I do not experience this problem with relinking views. If the view has a unique identifier candidate without having a Primary Key designated in SQL Server, Access does ask you to specify which field to use. And subsequent re-linking does retain that.

       

      I suspect if you don't designate the Primary Key for a newly linked view, of course, that subsequent relinking will not automatically "find" one and won't ask again for you to designate it.

       

      Try this. Delete the linked view(s) from Access and go through the original linking process again. This time take care to designate the Primary Key, or unique identifier, for each view during that original linking process. Then verify whether subsequent relinking retains or loses those Primary Keys.

      • George_Hepworth's avatar
        George_Hepworth
        Silver Contributor
        Jul 31, 2020

        George_Hepworth Follow up. If you use the option to refresh the link from the right-click menu in the Navigation Pane, you should be asked to designate the PK if there isn't one already designated.

Resources