Linked TSQL View Not updateable...

[lameid]

I feel is though I am missing something...

A view that I can edit the top 200 rows in SQL Management Studio and change data, is not updateable in Access.

It has worked previously I have even tried manually relinking it and specifying the key fresh rather than via creating a an index via code.

It is SQL 2012.

The purpose for the view is that the Unique index is a 64 bit integer (bigint), hence the composite unique key...

Any thoughts or insights? Trees to shake?

Edit: The Access Client is recently updated to Access 2016 so if I can link the table and use it that would be easy but it did not link any better than previous versions of Access.
The new issue occurs in Access 2013 as well as Access 2016.

 

[dhookom]

Can we assume if you created a query like:

SELECT DISTINCT [Your Specified Key Field] FROM [Your View Name]

It will return the same number of rows as:

SELECT [Your Specified Key Field] FROM [Your View Name]

Also, if you open the linked view in design view, is the key field identified?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[lameid]

If in T-sql I run...

SELECT COUNT(1), <Candidate Key Field List>
FROM <view>
GROUP BY <Candidate Key Field List>
HAVING COUNT(1) > 1

I get no results... The key I specify the view is the Candidate Key Field list is the same as my specified unique index for the linked table to the TSQL view which is where I am dumbfounded.

Edit: And your way 1,626,765 rows either way.

 

[dhookom]

If you open the linked view in design view, are the key fields identified?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[lameid]

Actually no the index is not identified...

This unfortunately fell away from priorities as something was on fire and now is important...

Today the view doesn't even want to link into Access....

I will probably take some manual intervention steps to make something work... IT is driving me bonkers here the last three weeks.

 

[lameid]

I am beginning to think this is an interaction issue with Access 2016 (perhaps patch level) and the SQL Native 11 driver.

 

[lameid]

Whine publicly, retry in afternoon... magically works...

I don't know. I just don't know.