Forum Discussion
Solved
Access doesn't close properly. A remaining background process can only be terminated in task manager
Since yesterday I noticed that in all my Access databases there is a problem when I close them. When I close a database, it leaves a background process that can only be terminated in Task Mana...
- Yes, here also the update available (Europe). Tested en fix the problem. Trusted Location not necessary any more. But I highly recommend it. Otherwise you will have problem starting from April. MS is blocking marcos. Check https://techcommunity.microsoft.com/t5/microsoft-365-blog/helping-users-stay-safe-blocking-internet-macros-by-default-in/ba-p/3071805
I think I found the culprit. I turned off Grammarly from the system tray and now MsAccess no longer get stuck as a background process. When I turn Grammarly back on the problem immediately returns. What's interesting is that Grammarly does not activate when I use MsAccess. (Apparently its still listening). I tried turning off Grammarly for all my Office Apps but no effect on MsAccess. This seems like a serious security issue. I hope MS locks this down fast.
By the way, not to be unsympathetic, but Grammarly is not a Microsoft product, so fixing the problem is probably in the court of Grammarly more so than on Microsoft.
- Thanks for passing that info along. I did actually try turning the compact on close on/off. No effect. I'm good for now. I've been using Access for 20 years and am used to dealing with all these types of issues. In this case, since uninstalling Grammarly I've had no issues.
- FWIW: the feedback I'm getting from the MVP group would suggest that this is more likely to be a problem in the time (and time delays) involved in starting and shutting down accdbs, especially if the accdb has "Compact on Close" set to on. It's not a breach, in that sense, if by breach the implication is that somehow the third-party software is actually intruding into the running code.
- I donnt reallly neeed grammmarllie aniway. Im justt glad i have a viabul worc around!!! Kind of scary that MSAccess is so fragile that it can be breached by a 3rd party app like Grammarly.