MS Access crashing/hanging issues

JB306yxe 256 Reputation points

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.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
797 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Klaus-Dieter Gundermann 1 Reputation point

    Thats "normal" MSAccess behavior...

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

    0 comments No comments