Instr() function crashes MS Access after 4/4/2024 update to office 16.0.17425.20146

Anonymous
2024-04-05T16:32:38+00:00

After Office updated to version 16.0.17425.20146 my MS Access crashes when running very simple functions. I created a new database with one table and one query.

Table1.Text1
Zebra
x-ray
4x4
Posted to X
Next
axe
None
extreme
wax

This works:

SELECT Table1.Text1, InStr(1,[Text1],"x") AS Field2

FROM Table1;

Query1
Text1 Field2
Zebra 0
x-ray 1
4x4 2
Posted to X 11
Next 3
axe 2
None 0
extreme 2
wax 3

This crashes MS Access before returning any results:

SELECT Table1.Text1, InStr(1,[Text1],"x") AS Field2

FROM Table1

WHERE (((InStr(1,[Text1],"x"))>0));

I tried compact/repair. Tried recreating the database from scratch. Rebooted my computer. I uninstalled and re-installed MS Office.

Any ideas??

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

54 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-04-08T11:17:14+00:00

    OMG, thank you, Tom! I managed to change to the Semi-Annual channel and I'm able to roll back to an older Office version.

    Everything works as normal now.
    Thanks so much again! =D

    Image

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-04-08T03:43:01+00:00

    No, I didn't. I've installed the 64-bit version since last year, and everything worked fine until today. Weirdly, the machine using the Access 32-bit version runs the same front end and the same Office version without error

    Image

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-04-08T03:36:31+00:00

    Yes, VBA compile without any errors

    Was this answer helpful?

    0 comments