MS Access crashing/hanging issues

Question

Good day all, we have been experiencing issues with MS Access 2019 on our machines. We have issues with all the workstations at various times and not every day. Last night, we had two machines at different times come back with issues. To fix the issue, a restart and then good to go.

For the Access Database, it is located on a Windows 2019 server running SQL. The front end is located on a local folder on each machine. The program is launched from the local drive.

The Error:
Log Name: Application
Source: Application Hang
Date: 2022-07-07 11:07:09 PM
Event ID: 1002
Task Category: (101)
Level: Error
Keywords: Classic
The program MSACCESS.EXE version 16.0.10387.20023 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Security and Maintenance control panel.

All machines are the same make, model, windows version, office version
Lenovo ThinkCentre M710s / 3Ghz i5-7400 / 8GB ram / Intel HD Graphics 630 display driver
Windows 10 Pro - Version: 21H1 build: 19043.1766
Office 2019 32bit Version: MSO 16.0.10382.20010

The problem is very random and hard to pinpoint. I’m hoping that I can get some guidance on this issue, maybe different things to look at.

Answer 1

Thats "normal" MSAccess behavior...

Is your database splitted in Frontend / Backend ?
you may try to "Compress / Repair" the database