question

FritzVedder-0522 avatar image
0 Votes"
FritzVedder-0522 asked FritzVedder-0522 answered

In Build 2205 Some (not all) Access Linked tables to SQL server stop working.

In build 2204 all Access linked tables worked fine, but now my users get updates and 20% of my Access linked tables are not working displaying every row/field with: "#Delete". Rolling back every workstation seems like a short term gain as we don't seem to have control over stopping the updates.

What patch or settings change must I deploy to fix this?
What exactly changed in Access so that if needed I can rebuild SQL server tables to allow the link to work?
(In the mean time I have been working to isolate what could be triggering this failure. It does not seem to be as simple as a data type or a size issues like MAX....)
What other possible fixes or workarounds are available?

The seems to affect both 2016 and 365 instances of the 2205 build, in our environment.

As a side note when the linked table is open from the object browser, it shows all data as "#Deleted" as I described above, however if I loop through a DAO Records set based on that link it pulls data fine..... Why?

Let me know if this belongs in another place and what that place is.

Thanks for any help...


office-access-dev
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @FritzVedder-0522
As this issue is related to Access, I would change the tag to be "office-access-dev".
Thanks for your understandings.


1 Vote 1 ·

1 Answer

FritzVedder-0522 avatar image
0 Votes"
FritzVedder-0522 answered

Thanks Emilyhua, Is the did you change the tag or is it that you are suggesting that I change it as it currently appears to be "office-access-dev"?

My issue has been resolved, the problem it turns out is only on tables that have a nvarchar datatype as the primary key... Not sure why build 2205 is not playing well with the driver we were using, but ODBC driver 17 should fix this..


https://codekabinett.com/rdumps.php?Lang=2&targetDoc=msaccess-bug-v2205-odbc-deleted-nvarchar-primary-key

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.