KB5002121 breaks MS Access runtime applications

Anonymous
2022-07-13T19:05:58+00:00

I just had a lengthy support call with a client. My MS Access (mde) file would not open. Received the message: "The expression on open you entered as the event property setting produced the following error. Requested type library or wizard is not a VBA project." I uploaded the uncompiled (mdb) file and that one ran fine. I tried creating a new mde file but it too would not run. After much head scratching, I check the latest updates and saw the following update installed today: Security Update to Microsoft Office 2013 (KB5002121) 32-bit Edition

After uninstalling the update the application ran perfectly fine. I have no other conclusion than this update caused it not to run. My client has temporarily turned off the automatic updates. Can anyone else confirm this issue?

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

95 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2022-07-17T07:38:13+00:00

    Hi Scottgem,

    we are doing soltution "recompile" as also Microsoft lists this as solution.

    However our app has customer specific module, whh is different for every customer. So we need to do this for more than 120 active customers many need both 32bit and 64bit.
    A very big workload for us and the customers for rolling out.
    And danger for customer if Patch (or 365 Update) happens before they have our update, they need to update each client manually. Big customer up to 100 computers! (normally we have an automatic update).

    Any information, if Microsoft will stop Patch for some days, to give users a chance to update before it rolls out?

    Wolfram

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-17T12:25:34+00:00

    Sorry to hear about the work load this creates in the interim. I am also waiting on Microsoft Office to fix the issue as it is not practical to recompile all the databases that have been deployed. I wish more testing is done before these updates are released given that this is not the first time these updates have caused issues to MS Access.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-07-17T17:33:12+00:00

    I've about one hundred customers with almost 5 pc each one, with different version of Access, with a big Microsoft Access application. So, I've about 500 pc with various version of Access. This application is constantly upgraded so, with an automatic system, I send every 2 weeks an upgrade to my customers. The upgrade overwrites the previous version of the accde. For someone I've recompilated the program with the right version of Access, but I can not think that I've to do that every 2 weeks for all my clients (every client has a customized version of the program, so I can not compile one version for all). Could I have a rapid solution for this problem?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-07-17T18:50:15+00:00

    Hi Massimiliano Zuffi,

    we allready started (with biggest customer > 100 Computer) to sent out Updates compiled in version with kb5002112. Our automatic update at customer is driven from the app itself. So we nned to run update BEFORE kb5002112. Otherwise customer needs manually to update each computer.

    Just some minutes ago customer running app with old 2010 reported next problem: 2010 is not able to read that accde. And reprts unknown database format (we use 2007 - 2016).

    Wolfram

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-07-17T18:51:46+00:00

    Newest problem:

    Just some minutes ago customer running app with old 2010 reported next problem: 2010 is not able to read that accde. And reprts unknown database format (we use 2007 - 2016).
    I tested this here and can confirm the problem.

    Was this answer helpful?

    0 comments