Feedback by UserVoice

I suggest you ...

← Access (Desktop Application)

Fix Bug - InStr And InStrRev

InStr or InStrRev function results in error or crashes database if sort order is “General”).
Work around: Options > General > New database sort order > General - Legacy’, followed by ‘compact database’.
The behaviour is very odd in that e.g. it may or may not work first time after reboot / logon, but fails subsequently. Compacting and then restarting the database never fixes the issue.
This problem resulted from recent (Quarter 2 to July 2020) Windows and / or Access 2019 updates.

1 vote
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Ron shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Colin commented  ·   ·  Flag as inappropriate

    Thank You! I was puzzled by the sudden crashing caused by the Instr.

Access (Desktop Application): Queries

Categories

Feedback and Knowledge Base

(thinking…)