VBScript.RegExp Assertion Failure!

Software Bug

Huston we have yet another problem!

We are seeing multiple reports that a recent update has broken, at the very least VBScript.RegExp, resulting in the following error:

Assertion failed!

Program: …
File: g:\vba\src\65_VC8\VBA\rt\rtre.cxx
Line: 946

Expression: replaceVar.vt == VT_BSTR

For information on how your program can cause an assertion failure, see the Visual C++ documentation on asserts
(Press Retry to debug the application – JIT must be enabled) Microsoft Visual C++ Runtime Library

MC Visual C++ runtime library - Assertion failure - expression replaceVAR.vt == VTBSTR
Hi, one of my front ends has just started getting this error.
when I click on a button to open a form no error or debug just as below, Abort just freezes have to do a full close X, Ignore just keeps flashing the same message.
Retry sometime continues on normally but no info. this is in a…
From the MSAccess community on Reddit
Explore this post and more from the MSAccess community
Assertion failed! Microsoft Office Upgrade to Version 2508

 

Now that I Googled the subject, I see that Mike Wolfe has written an article on the issue:

Bug Alert: Assertion Failed on RegExp Calls in Access 2508
Two separate sightings of the same error on two entirely different machines within hours of each other is likely no coincidence. I hope this doesn’t ruin my long weekend…
Read More

and has identified the root cause as being the update to Access version 2508!

I’m not going to double up on Mike’s article. So, go look it over as he offers a very simple workaround to this latest Microsoft bug at the end of his article!

Microsoft has been made aware of this issue.

4 responses on “VBScript.RegExp Assertion Failure!”

  2. Ant Cross

    Hi Daniel
    I have used this article to pose an idea related to Microsoft’s intention to disable VBScript.
    1. What stops me from making a copy of the VBScript Runtime DLL and after Microsoft remove it from my system, to re-instate it?
    2. Microsoft have PROMISED to stop updating my Win10 in October – which is prior to VBScript deprecation. With that in mind, my VBScript on Win 10 device remains intact?
    I would appreciate your thoughts on the above
    Regards

    1. Daniel Pineault Post author

      It might be possible, but impossible to guarantee it will work until MS does whatever they’re going to do! The problem is we just don’t know anything. Microsoft, per the usual, has not shared any REAL information with users. Since there are a few alternative for RegExp and Collections, I’d recommend implementing them (doesn’t have to be MS RegExp class), but the bigger issue for FSO still remains.

      Also note, Microsoft just announce that they have included, as of Version 2508, RegExp Classes in VBA to replace what is being deprecated. Learn more at:

      Microsoft Adds Native RegExp to VBA Ahead of VBScript Deprecation