{"id":24668,"date":"2022-05-30T10:20:58","date_gmt":"2022-05-30T08:20:58","guid":{"rendered":"http:\/\/159.69.82.204\/win\/?p=24668"},"modified":"2022-05-30T11:21:36","modified_gmt":"2022-05-30T09:21:36","slug":"microsoft-access-gibt-es-probleme-beim-sql-datenbankzugriff-wegen-odbc-treiber","status":"publish","type":"post","link":"https:\/\/borncity.com\/win\/2022\/05\/30\/microsoft-access-gibt-es-probleme-beim-sql-datenbankzugriff-wegen-odbc-treiber\/","title":{"rendered":"Microsoft Access: Issues with SQL database access because of ODBC driver?"},"content":{"rendered":"

[German<\/a>]Brief information for the readership and at the same time the question if someone is already affected. I received a user message that Microsoft Access suddenly had problems with SQL database access. All databases suddenly showed the value '#DELETED' in the tables. The problem is the Microsoft SQL Server ODBC driver (shipped with Windows), which seems to go on strike after Office updates.<\/p>\n

<\/p>\n

ODBC access to SQL server is faulty<\/h2>\n

\"\"German blog\u00a0 reader Axel H. contacted me by mail on Saturday, May 28, 2022 to report a specific observation in the Microsoft Access environment related to accesses to a Microsoft SQL server. Axel wrote (translated):<\/p>\n

enclosed is a note from me. I was called today by a colleague whose Microsoft Access suddenly did not want to work properly with the SQL Server work properly anymore.<\/p>\n

All ODBC tables included in Microsoft Access show only '#DELETED' as content.<\/p>\n

After some searching, I found out that it was the 'original' Microsoft SQL Server ODBC driver, the one that comes with Windows.<\/p><\/blockquote>\n

Sounds bad, a manual fix is required.<\/p>\n

New ODBC driver versions work<\/h2>\n

Microsoft ODBC Driver for SQL Server is a single dynamic-link library (DLL) that provides runtime support for applications that use native code APIs to connect to SQL Server. Microsoft ODBC Driver 18 for SQL Server should be used to create new applications or enhance existing applications that use the newer SQL Server features.<\/p>\n

The current version 18.0.1.1 dated February 15, 2022 is offered for SQL Server 2022 Preview here<\/a>, on Github there is this overview<\/a> about different driver versions. After some testing, Axel was able to determine that newer versions of the ODBC driver such as v13 and v17 do not show the problem when accessing the databases.<\/p>\n

Trouble on the way, Office rollback helps<\/h2>\n

Axel wrote, that the version, supplied by Windows, is used however surely to >90%, in the field – since Windows brings it along (see here<\/a> for instance) and does not have to be installed extra. So there could be a lot of trouble within the next days. Axel told me, that Microsoft Office Professional Plus 2019 C2R 32-bit, version 2205 build 16.0.15225.20028 dated 2022-05-24, was affected in his environment (no idea, whether other Office versions are affected). After he did a rollback of Microsoft Office to version 16.0.15128.20248 from 2022-05-17, everything worked again immediately.<\/p>\n

Axel concludes that the problem is not really with the ODBC driver, but with the Office update and how it 'cooperates' with the ODBC driver. He has therefore deactivated the Office C2R updates via the registry, so that the latest version is not immediately applied. Anyone else with such experiences?<\/p>\n

Addendum:<\/strong> There are others who observed this, see the comments<\/a> to my German blog post.<\/p>\n","protected":false},"excerpt":{"rendered":"

[German]Brief information for the readership and at the same time the question if someone is already affected. I received a user message that Microsoft Access suddenly had problems with SQL database access. All databases suddenly showed the value '#DELETED' in … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[463,11],"tags":[1782,47,2019,195],"class_list":["post-24668","post","type-post","status-publish","format-standard","hentry","category-issue","category-office","tag-access","tag-issue","tag-odbc","tag-update"],"_links":{"self":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/24668","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/comments?post=24668"}],"version-history":[{"count":0,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/24668\/revisions"}],"wp:attachment":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/media?parent=24668"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/categories?post=24668"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/tags?post=24668"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}