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
It's an established unofficial rumor that MS was considering to dump Access, or rather wanted to replace it with more profitable programs. But there are simply too many developers using this great tool.
"Established" meaning some people love to repeat it. "Unofficial" meaning other people made it up to justify their own agenda against Access.
I think there IS some truth to the proposition that Microsoft would rather make more money than less money (...more profitiable...), if possible. But then, that's true of about 99% of businesses in the world. Those that would prefer to be less profitable have other motives.
I think there IS some truth to the proposition that Microsoft would rather make more money than less money (...more profitiable...), if possible. But then, that's true of about 99% of businesses in the world. Those that would prefer to be less profitable have other motives.
- When you hide the application itself, you need to make sure you can recover without resort to the task manager. Suggest you do ONE of the following
1. Remove the close button on the form or hide the entire control box including the close button
2. Add code to the form On Close event to close the app i.e. Application.Quit
3. Restore the taskbar icon so you have a method of recoveryisladogs I added Application.Quit to the On Close event of my form but got the following error:
Note however, my form and VB editor stayed open, and my Access window closed. I had to end the task manually.
In that case, either you are
a) still using a version that was affected by the bug from earlier this year - if so, a version update will fix it
b) or you have an issue with your code. Suggest you upload a cut down version of your database with most of the data and all unrelated objects removed.
- As you suggested, I added Application.Quit in the On Close event. The issue only happened intermittently, so we'll wait to see the results.
Thank you.
