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

References are just the basics. None are flagged as broken. I performed the office repair when this first happened. (full online version) It told me there was some 32-bit Office component installed and it uninstalled my 64-bit programs. I looked for the offending 32-bit component. Uninstalled MS database engine. Uninstalled SQL Server Migration Tool for Access. Rebooted. Installed 64-bit Office. Access still crashed when running the offending query. Rebooted and ran the MS Office repair again, with no errors or issues. Access still not fixed.

In your first grid Line 1 is blank. Delete that record. Still the same problem?

People are looking into it, but so far cannot reproduce it. VBA window > Tools > References: you only have the standard four, and they are not listed as Broken? Control Panel > Programs and Features: perform an Office Repair. Still the same issue? Switch the default printer to "Microsoft Print to PDF". Still the same issue?

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

Anonymous

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

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

Answer accepted by question author

Anonymous

Hi,

The documenting article on AFo now has more information about the worarounds and the planned fix date by Microsoft.

Servus
Karl
****************
Access DevCon - online conference April 18+19
Access News
Access Forever
Access-Entwickler-Konferenz AEK

0 comments

Answer accepted by question author

Anonymous

Hi,

I installed the new version 2404 which was published on May 1. In my tests the bug has been fixed.

Therefore, I've updated our documenting article on AFo with the fix information.

Servus
Karl
****************
Access Forever
Access News
Access DevCon
Access-Entwickler-Konferenz AEK

0 comments

54 additional answers

Anonymous

2024-04-05T18:37:28+00:00

References are just the basics. None are flagged as broken.

I performed the office repair when this first happened. (full online version) It told me there was some 32-bit Office component installed and it uninstalled my 64-bit programs. I looked for the offending 32-bit component. Uninstalled MS database engine. Uninstalled SQL Server Migration Tool for Access. Rebooted. Installed 64-bit Office. Access still crashed when running the offending query. Rebooted and ran the MS Office repair again, with no errors or issues. Access still not fixed.
Was this answer helpful?

0 comments No comments
Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator

2024-04-05T17:45:55+00:00

In your first grid Line 1 is blank. Delete that record. Still the same problem?
Was this answer helpful?

0 comments No comments
Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator

2024-04-05T17:22:32+00:00

People are looking into it, but so far cannot reproduce it.

VBA window > Tools > References: you only have the standard four, and they are not listed as Broken?
Control Panel > Programs and Features: perform an Office Repair. Still the same issue?
Switch the default printer to "Microsoft Print to PDF". Still the same issue?
Was this answer helpful?

0 comments No comments