Forum Discussion
Access doesn't close properly. A remaining background process can only be terminated in task manager
- 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
StuBux Make the location of the database a 'Trusted Location' in the trust center. Microsoft just released a patch that caused this issue.
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\DBLocation]
"Path"="C:\\DBFolder\\"
"AllowSubfolders"=dword:00000001
"Description"="Local DB Folder"
"Date"="2/2/2022 7:44 PM"
Prior to this patch, files in the Users\username\AppData folder were allowed but now they are being treated differently. It may be true for other locations as well.
The problem: Access closes normally but will not reopen giving an error message saying something about you do not have permission..."
NiteOwl's Solution solution fixed the problem for me on 2022-12-15.
The solution is here:
https://techcommunity.microsoft.com/t5/access/access-doesn-t-close-properly-a-remaining-background-process-can/m-p/3103807Here is the post to look for:
NiteOwl replied to NiteOwl:
------------------------------
Feb 03 2022 10:34 AMYou can also somewhat automate it by creating a .reg script or using group policy. The settings you need are:
[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Security\Trusted Locations\DBLocation]
"Path"="C:\\DBFolder\\"
"AllowSubfolders"=dword:00000001
"Description"="Local DB Folder"
"Date"="2/2/2022 7:44 PM"Prior to this patch, files in the Users\username\AppData folder were allowed but now they are being treated differently. It may be true for other locations as well.
------------------The post be NiteOwl would not run as a .reg file. But it works: I opened regedit and manually created the key DBLocation at the end of the path cirted by NiteOwl. Then I manually created the sub keys and set the values he listed being careful to set the datatype of each value to match those observed in existing keys created in Trusted Locations.
