MC Visual C++ runtime library - Assertion failure - expression replaceVAR.vt == VTBSTR

[bignose2]

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 accdb so able to go into VB.

Exactly the same front end on 2 different windows 10 PC (same state of upgrades) are fine?

Quite a lot of code on open & load so could start removing but just did not like this level error.
Not sure if the File :g:\vba ... is relevant as G is google drive on that PC?

Any ideas?

 

[bignose2]

After more debug F8 finially found the trigger, seemed not to flag up before but might have been me!

set regex =createobject(vbscript.regex)

fine on the other PCs so to investigate.

Is there something I can perhasp re-install or best to really try to find the reason.
been fine for years

 

[Gasman]

Another member has had a windows update which is causing a working system to crash.

VBA code crashes after installing KB5064081 update

Hello, After installing windows update KB5064081 on Windows 11 machine, the following piece of code crashes on Access 2016: Public Sub CreateTable(strPath As String) Dim cat As ADOX.Catalog Dim tbl As ADOX.Table Dim idx As ADOX.Index Dim flag As Boolean Set cat = New ADOX.Catalog cat.Create...

www.access-programmers.co.uk

Any Office updates as well?

 

[isladogs]

Hi @bignose2
This bug was first reported by Mike Wolfe on 29 Aug with details passed on to the Access team the same day

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...

nolongerset.com

I included it in my article summarizing all known bugs for July/August:

Bug Summary - July/Aug 2025

This summarises all known Access bugs and one Office bug reported in July / August 2025 together with symptoms and action taken.

www.isladogs.co.uk

There is a workaround described in both articles

 

[bignose2]

Very many thanks,
Sorry did not do too much research just now, just go back & need to fix asap.

last week I had just flown out of the country for my daughters wedding,

checked & double checked all working, back PC's etc etc. before going so could not believe this as rarely go away.

following day got the message, error as above.
Tried to fix remotely, could not find but was difficult with just a phone size screen & being rather occupied with wedding.

This was preventing my staff emailing or texting which is now my main source for communications, bookings etc, dozens each day so a bit screwed.

one backup PC was in my home which staff could use but far from idea, the other was a laptop but a small screen. they managed but was a real pain especially when a bug & nothing to do with me.

Thanks again.

 

[isladogs]

You’re welcome. As I mentioned, both articles describe a workaround which you can use.

 

[arnelgp]

you double check the spelling of your createobject(), should be:

set regex = CreateObject("vbscript.regexp")

 

[Gasman]

you double check the spelling of your createobject(), should be:

set regex = CreateObject("vbscript.regexp")

I think that is just a typo due not copying and pasting?

I have this in my code, it has quotes in it?

    Set regex = CreateObject("VBScript.RegExp")