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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-04-10T17:14:07+00:00

    Thanks for your persistence, GPG!

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-04-10T12:04:56+00:00

    That's good news, thanks for the update.

    Was this answer helpful?

    0 comments
  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2024-04-10T11:51:16+00:00

    We just had word from the Access team. They've been able to reproduce the problem using the sample accdb provided.

    The problem is now under review and they will let us know when they have an update on it.

    THANK YOU to everyone who persisted in identifying and reporting the problem.

    Was this answer helpful?

    0 comments