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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-07-18T16:05:49+00:00

    Dear M Allan,

    we also don't follow the recompile way any longer. It does not work for installed Access Runtime and on customers still running 2010 it is seen as "unexpected database format" (though Format 2007 to 2016 was selected).

    What we found as working is this approach:

    1. remove original start form
    2. insert a siple new form with one button 2a. button on_click event has only this (betwwen error handler): 
      DoCmd.Close acForm, Me.NAME 

DoCmd.OpenForm "your\_standard\_start\_from"

    no other code!

    1. select this simple form as start form
    2. compile and test

    We found only two small issues:

    a) if clicking before acces really open the Patch error comes up, but works on second click

    b) it is one additional click for users on starting the app

    Hth Wolfram

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-18T15:55:27+00:00

    Dear Kevin62,

    sorry, I think you wrote to wrong person. I didn't provide any VBA.

    As answered before, we don't do HTML export.

    regards Wolfram

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-07-18T15:04:54+00:00

    Hi Wolfram, could you try it and see if it's working? For some reason my ability do output to html or anything else quit working and I was curious if this is something also affected by this recent update. It generates a error 2587 and will not ouput. Thanks

    The visual basic code you entered contains a syntax error or the output procedures are not available

    Was this answer helpful?

    0 comments
  4. Anonymous
    2022-07-18T09:45:53+00:00

    Hi scottgem,

    We stopped rolling out new compiled version.

    Customers running Access Runtime 2016 Version 16.0.15330.0.20246 can't run the accde which is compiled in Microsoft 365 Apps for Enterprise Access Version 16.0.15330.0.20246.

    It is dramatical now!

    Does MS stop installing this Updates / Patches??

    Wolfram

    Was this answer helpful?

    0 comments
  5. Anonymous
    2022-07-18T06:27:57+00:00

    We stopped rolling out new compiled version.

    Customers running Access Runtime 2016 Version 16.0.15330.0.20246 can't run the accde which is compiled in Microsoft 365 Apps for Enterprise Access Version 16.0.15330.0.20246.

    It is dramatical now!

    Wolfram

    Was this answer helpful?

    0 comments