Access randomly crashing when I try to filter

Anonymous
2024-06-05T15:25:06+00:00

Having this issue for the past few days.
Every once in a while, when I try to filter a field, access will crash. It doesn't matter how big the table I'm trying to filter is.

Sometimes it crashes when I'm not even touching it. It's just open in the background when I'm working on something else.
More rare though. So not sure if it's even related.

Any ideas?

Microsoft 365 and Office | Access | For home | Other

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

53 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-12T18:40:21+00:00

    Hi,

    We will keep the bug status up to date in our documenting AFo article and also inform you here when there is important news.

    A few minutes ago George changed the status in the article to:

    > Microsoft is working on releasing a fix for the problem. We should be able to provide details shortly.

    If everything works out, the fix will come to version 2407 very soon. Your cooperation has helped to speed things up!

    Servus
    Karl
    ****************
    Access Forever News DevCon
    Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

    Was this answer helpful?

    0 comments
  2. George Hepworth 23,120 Reputation points Volunteer Moderator
    2024-08-12T15:46:00+00:00

    I got it and it was sent on to Microsoft. Thank you. Very thorough and precise.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-12T14:00:32+00:00

    For those affected who can't rollback nor wait for the fix, there is a cumbersome workaround that works for us.

    Hi Mark,

    I never use the the Form's Filter, but construct an SQL-string on the spot, and use that string as RecordSource.

    Probably you use an QueryDef as RecordSource. What happens if you construct an "filtered" SQL-string like:

    SQL-string = My\_query.SQL & " WHERE " & my\_filter

    and use that SQL-string as RecordSource in the form?

    Working in this way is very dynamical. You can change the "filter" and the sorting while the form is opened.

    Imb.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-08-12T13:05:16+00:00

    I also sent a video in. For those affected who can't rollback nor wait for the fix, there is a cumbersome workaround that works for us. Enable the Form's "Data Sheet" view, execute the filter while in Data Sheet view and return to Form view to view the results. Applying a filter while in Data Sheet does not appear to cause the crash, but (re)training users may be a pain.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2024-08-12T12:20:46+00:00

    Thanks Karl! I did send a report and video to @groverparkgeorge over the weekend as well. Hopefully Microsoft will act upon this quickly. Our IT department will not roll back the update on our virtual desktops, so my colleagues in the field are stuck right now. =)

    Was this answer helpful?

    0 comments