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

%3CLINGO-SUB%20id%3D%22lingo-sub-1505925%22%20slang%3D%22en-US%22%3EWhen%20I%20use%20linked%20table%20manager%20to%20Reconnect%20tables%20VIEW-SQL%20the%20Key%20deleted%20-How%20to%20solve%20this%20pro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505925%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20use%20linked%20table%20manager%20to%20Reconnect%20tables%20VIEW-SQL%20the%20Key%20deleted%20-How%20to%20solve%20this%20problem%3F%3F%20in%20ms%20access%202019%20(365)%3C%2FP%3E%3CP%3Ehi%3C%2FP%3E%3CP%3EWhen%20I%20use%20linked%20table%20manager%20to%26nbsp%3B%20Reconnect%20tables%20VIEW%20the%26nbsp%3B%20Key%20deleted%20--%26nbsp%3B%20in%26nbsp%3B%20ms%20access%202019%26nbsp%3B%20(365)%3C%2FP%3E%3CP%3EVIEW%26nbsp%3B%20-SQL%3C%2FP%3E%3CP%3Efor%20example%3C%2FP%3E%3CP%3Edbo_movment%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B(SQL%20)%3C%2FP%3E%3CP%3EThe%20problem%20is%20only%20in%20VIEW%3C%2FP%3E%3CP%3Ein%20Another%20table%20(SQL%20)%26nbsp%3B%20has%20no%20problem%3C%2FP%3E%3CP%3EPrevious%20versions%20of%20Access%20had%20no%20problem%3C%2FP%3E%3CP%3EThe%20problem%20is%20only%20in%20the%202019%20access%3C%2FP%3E%3CP%3EIt's%20a%20serious%20problem%20-%20that%20doesn't%20allow%20me%20to%20work%26nbsp%3B%20With%20Access%202019%3CBR%20%2F%3EThe%20issue%20is%20also%20in%20the%20version%26nbsp%3B%2064BIT%20and%20also%26nbsp%3B%20In%26nbsp%3B%20version%26nbsp%3B%2032BIT%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1505925%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1506087%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20use%20linked%20table%20manager%20to%20Reconnect%20tables%20VIEW-SQL%20the%20Key%20deleted%20-How%20to%20solve%20this%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506087%22%20slang%3D%22en-US%22%3EWhat%20build%20are%20you%20running%2C%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI'd%20suspect%20you%20are%20dealing%20with%20the%20following%20bug%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.devhut.net%2F2020%2F01%2F17%2Faccess-bug-sql-server-identity-bug-with-access%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.devhut.net%2F2020%2F01%2F17%2Faccess-bug-sql-server-identity-bug-with-access%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1556279%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20use%20linked%20table%20manager%20to%20Reconnect%20tables%20VIEW-SQL%20the%20Key%20deleted%20-How%20to%20solve%20this%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1556279%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459380%22%20target%3D%22_blank%22%3E%40Daniel_Pineault%3C%2FA%3E%3C%2FP%3E%3CP%3Ehi%3C%2FP%3E%3CP%3EI%20was%20waiting%20for%20a%20new%20version%3CBR%20%2F%3EAnd%20yet%20the%20problem%20is%20not%20solved%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22access11.png%22%20style%3D%22width%3A%20401px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209069i1BDCD59A390A0945%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22access11.png%22%20alt%3D%22access11.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558481%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20use%20linked%20table%20manager%20to%20Reconnect%20tables%20VIEW-SQL%20the%20Key%20deleted%20-How%20to%20solve%20this%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558481%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F720604%22%20target%3D%22_blank%22%3E%40yosimzl%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20Access%202019%20installed.%20I%20do%20not%20experience%20this%20problem%20with%20relinking%20views.%20If%20the%20view%20has%20a%20unique%20identifier%20candidate%20without%20having%20a%20Primary%20Key%20designated%20in%20SQL%20Server%2C%20Access%20does%20ask%20you%20to%20specify%20which%20field%20to%20use.%20And%20subsequent%20re-linking%20does%20retain%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20suspect%20if%20you%20don't%20designate%20the%20Primary%20Key%20for%20a%20newly%20linked%20view%2C%20of%20course%2C%20that%20subsequent%20relinking%20will%20not%20automatically%20%22find%22%20one%20and%20won't%20ask%20again%20for%20you%20to%20designate%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this.%20Delete%20the%20linked%20view(s)%20from%20Access%20and%20go%20through%20the%20original%20linking%20process%20again.%20This%20time%20take%20care%20to%20designate%20the%20Primary%20Key%2C%20or%20unique%20identifier%2C%20for%20each%20view%20during%20that%20original%20linking%20process.%20Then%20verify%20whether%20subsequent%20relinking%20retains%20or%20loses%20those%20Primary%20Keys.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1558491%22%20slang%3D%22en-US%22%3ERe%3A%20When%20I%20use%20linked%20table%20manager%20to%20Reconnect%20tables%20VIEW-SQL%20the%20Key%20deleted%20-How%20to%20solve%20this%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1558491%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126074%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3BFollow%20up.%20If%20you%20use%20the%20option%20to%20refresh%20the%20link%20from%20the%20right-click%20menu%20in%20the%20Navigation%20Pane%2C%20you%20should%20be%20asked%20to%20designate%20the%20PK%20if%20there%20isn't%20one%20already%20designated.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22refreshlinknavpane.png%22%20style%3D%22width%3A%20280px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F209296iAA9889CAF3AFC530%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22refreshlinknavpane.png%22%20alt%3D%22refreshlinknavpane.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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  Key deleted --  in  ms access 2019  (365)

VIEW  -SQL

for example

dbo_movment         (SQL )

The problem is only in VIEW

in Another table (SQL )  has no problem

Previous versions of Access had no problem

The problem is only in the 2019 access

It's a serious problem - that doesn't allow me to work  With Access 2019
The issue is also in the version  64BIT and also  In  version  32BIT

 

 

4 Replies
Highlighted
Highlighted

@Daniel_Pineault

hi

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

 

access11.png 

Highlighted

@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.

Highlighted

@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.

refreshlinknavpane.png