'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Microsoft Access Crashing When Filtering a Table or Query
Question details
Microsoft Access closes unexpectedly when the user tries to apply a filter to a table or a SELECT query.
- Product
- Microsoft Access
- Device & OS
- Windows
- Scenario
- Applying filters to a table or a SELECT query within a database, particularly after completing a recent Office update.
- Observed behavior
- The Access application crashes and closes without warning, interrupting the user's database workflow.
Before making system changes, verify if the crash occurs on a single specific database or all databases, and check if opening the file on another computer produces the same result.
Disable the Monaco SQL Editor
Turning off the Monaco SQL Editor in Access Options often resolves crashing issues specific to recent updates, such as Version 2410.
Microsoft introduced the Monaco SQL Editor to improve query writing, but in certain builds (like Version 2410), it can cause instability when filtering tables or running SELECT queries.
Open Microsoft Access, click on 'File' in the top left corner, and select 'Options'.
In the Access Options dialog box, click on 'Current Database' located in the left-side navigation pane.
Scroll down the list of options to find the checkbox labeled 'Enable Monaco SQL Editor' and clear it.
Click 'OK' to save the changes, completely close your database, and reopen it to apply the new settings.
Perform an Online Repair of Microsoft 365
If multiple databases are crashing across the application, repairing your Office installation can fix corrupted system files causing the crashes.
Revert to an Earlier Version of Office
If the crashing started immediately after a recent Microsoft Office update, rolling back to a previous stable build can act as a temporary workaround until Microsoft releases a patch.
Looking for a Stable Office Suite? Try WPS Office
While Microsoft Access is a specialized database tool, dealing with frequent Office application crashes can disrupt your entire workflow. If you need a reliable, lightweight, and free alternative for Word, Excel, and PowerPoint tasks, WPS Office provides seamless compatibility and high performance without the heavy resource demands.
Frequently Asked Questions
Why does Microsoft Access crash only when I filter certain tables?
This often occurs due to a known bug in specific Office updates (such as Version 2410) related to the Monaco SQL Editor interacting with complex table properties. Disabling the editor typically prevents the crash.
Will repairing Microsoft 365 delete my Access databases?
No, performing an Online Repair only fixes the application installation files and registry keys of the Microsoft Office suite. Your personal databases (.accdb or .mdb files) will remain completely untouched.
How do I know what version of Microsoft Access I am currently using?
Open Microsoft Access, click on 'File' in the ribbon, and select 'Account' at the bottom left. Under 'Product Information', you will see your version, build number, and update channel next to the 'About Access' button.
Can a corrupted database file cause Access to crash on filtering?
Yes. If the crashing issue happens only on one specific database file and works fine on others, that specific file might be corrupted. You can try using the 'Compact and Repair Database' tool found under the 'Database Tools' tab to resolve file-specific corruption.
