{"id":25648,"date":"2022-07-14T00:15:00","date_gmt":"2022-07-13T22:15:00","guid":{"rendered":"http:\/\/159.69.82.204\/win\/?p=25648"},"modified":"2022-07-19T15:43:03","modified_gmt":"2022-07-19T13:43:03","slug":"office-updates-destroys-access-run-time-and-apps","status":"publish","type":"post","link":"https:\/\/borncity.com\/win\/2022\/07\/14\/office-updates-destroys-access-run-time-and-apps\/","title":{"rendered":"Office updates destroys Access run time and apps"},"content":{"rendered":"

[German<\/a>]I got reports, that Microsoft Office 365 version 2206 (Build 15330.20246) is causing issues with VBA in Access applications. And I got reports, that KB5002121 for Office 2013 and KB5002112 for Office 2016 is causing the same issue.<\/p>\n

<\/p>\n

1# Report on Office 365 issues<\/h2>\n

\"\"The first report I received via Twitter. The person in question thinks that Microsoft has once again ruined Access with an Office update and posted the following screenshot of the error message in a tweet<\/a> – the German text means translated:<\/p>\n

\"Access-Fehler\"<\/a><\/p>\n

You have entered the expression On Load as the event property setting. This expression has caused an error: Requested class library or wizard is not a VBA project.<\/p><\/blockquote>\n

If you search for the bug, there are quite a few hits – and a support post<\/a> from April 2022. From the post, I conclude that there was either a reference to a library disabled (you can find out in the VBA environment) or a reference broken by the update. Anyone else who happens to have this bug and can elaborate? The user replied on Twitter:<\/p>\n

The error occurs with our customers who have installed update 15330.20246. It disappears when you revert to 15330.20230 OR create a new ACCDE with the newer Access version. This will then run on both builds, but not on older Office versions. By this I mean Access 2013 or 2010.<\/p><\/blockquote>\n

So it seems to be related to the latest update. However, the user also points out that build 15330.20246 is not yet listed in the Microsoft 365 update history<\/a>. At this point, my thanks to the reader for the information.<\/p>\n

#2 Report on Access Run Time issues<\/h2>\n

A short time later I received the notification within the following tweet<\/a>, that an installed Access Run Time (RT) also seems to show these errors.<\/p>\n

\"Run<\/a><\/p>\n

#3 Report Office 2013\/2016 also affected<\/h2>\n

In another tweet<\/a>, the first user reported, that the error occurs after installing Office 2013 update KB5002121<\/a> or Office 2016 update KB5002112<\/a>. In all cases, the Access error in Run Time or in Access apps accessing ACCDE files has been gone, after the update install has been rolled back.<\/p>\n

Addendum:<\/strong> Microsoft says<\/a>, they are aware and the team is looking into that issue (some affected German blog reader had created tickets). On reddit.com there is this thread<\/a> about that issue.<\/p>\n

Addendum 1:<\/strong> See\u00a0Fix for Access ACCDE\/MDE bug (VBA library bug)<\/a> for fixes.<\/p>\n","protected":false},"excerpt":{"rendered":"

[German]I got reports, that Microsoft Office 365 version 2206 (Build 15330.20246) is causing issues with VBA in Access applications. And I got reports, that KB5002121 for Office 2013 and KB5002112 for Office 2016 is causing the same issue.<\/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,22],"tags":[1782,47,195],"class_list":["post-25648","post","type-post","status-publish","format-standard","hentry","category-issue","category-office","category-update","tag-access","tag-issue","tag-update"],"_links":{"self":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/25648","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=25648"}],"version-history":[{"count":0,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/posts\/25648\/revisions"}],"wp:attachment":[{"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/media?parent=25648"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/categories?post=25648"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/borncity.com\/win\/wp-json\/wp\/v2\/tags?post=25648"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}