MS Access crashes when filtering a table or SELECT query

Anonymous
2024-12-30T15:17:30+00:00

Win 11, MS 365 Apps for Enterprise 16.0.18129.20200

MS access DB crashes when attempting to put new filter in field of a Query.

Did compact/repair. Tried filter in other fields, still just crashes without displaying error.

Google searches revealed this is a re-occurring issue that MS must patch to fix. whatever last patch they pushed, must have broken the functionality,

Microsoft 365 and Office | Access | For business | 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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-12-30T20:34:18+00:00

    Hi Shane,

    Thanks for posting in the community. We are happy to help you.

    I understand the inconvenience you are experiencing. Since we are communicating in the community, I am not able to check your environment directly. Therefore, I would like to gather more information for initial troubleshooting. You can share the results with us, which will help us narrow down the problem.

    1. Is the problem in a specific database, or is it also in other databases? In addition, if possible, I suggest you open the database on another machine to see if is specific to your current setup.

    If the problem is also in other databases, I recommend you repair Access and then check again. Go to Windows Settings> Apps> Installed apps> find the Office suite, such as Microsoft 365 Apps for enterprise en-us> select Modify> choose Online Repair. After repairing, please open the database and check again.

    1. Since you are using Access Version 2410, I recommend you disable Monaco SQL Editor and then check again.

    Click File> Options> Current Database> uncheck the "Enable Monaco SQL Editor" option> OK. Then close the database and reopen it. See if the crash problem persists.

    1. I would like to know if you are having this problem after updating Office/Access. If not, please point it out and let us know. If so, I suggest you revert to an earlier version of Access, such as Version 2409 (Build 18025.20242). See if the problem persists.

    How to revert to an earlier version of Office

    Roll-back to previous versions of Office

    Disclaimer*: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.*

    When you have any updates, please feel free and come back to share them with us.

    Sincerely,

    George | Microsoft Community Moderator

    Was this answer helpful?

    0 comments