Forum Discussion
Florian1290
Feb 02, 2022Copper Contributor
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...
- Feb 08, 2022Yes, 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
Feb 02, 2022
Hi,
You are not alone. There are reports about it in all Access forums of the world. I answered it like this several times:
According to many posts in the last days M365 Current Channel version 2201 build 16.0.14827.20158 of Jan 26 causes
- a persistent .laccdb, an Access ghost process
- error 3048 cant open any more databases
- other errors like "already in use by Admin"
The only remedy so far is to revert back to an older build of M365. See also the M365 version history.
I've reported it to Microsoft, too.
Servus
Karl
************
Access News
Access DevCon
- CARKIS51Feb 06, 2022Copper Contributor
If by now you don't know, the solution is simple: add the folders where the front and backend are located to Trusted Locations. AND You have to do it for every single user in your network, a step I missed doing the first time and the other two users kept having the problem.
- George_HepworthFeb 06, 2022Silver ContributorKeep in mind, though, that there have been reports where the Trusted Location workaround wasn't effective. See this note, for example, on the MS site:
https://support.microsoft.com/en-us/office/access-is-unable-to-close-and-leaves-lockfile-active-b2dce32b-b8b0-41f1-ba40-7876e524d9da
Note: This workaround will not work if AMSI (Antimalware Scan Interface) is enabled for all documents. More information about AMSI can be found here: Office VBA + AMSI: Parting the veil on malicious macros - Microsoft Security Blog
Also, it's not always clear that people are fully implementing this, but one has to be cautious.- CARKIS51Feb 06, 2022Copper ContributorThanks. I guess I was one of the several fortunate ones. Glad to know that they'll be releasing a permanent fix.
- Feb 04, 2022
Hi,
The Microsoft Access team has published a first version of a support article about this update bug: https://support.microsoft.com/en-us/topic/b2dce32b-b8b0-41f1-ba40-7876e524d9da
In it a fix is announced, but so far without a date. Until then, the workaround recommended is to put the database in a trusted location.
Servus
Karl
************
Access News
Access DevCon- Feb 05, 2022
Hi,
Since we've seen a lot of positive reports about it and the trusted location is now also the officially recommended workaround by MSFT: In order to keep the thread readable, I think it would be good to especially post here when the workaround does NOT help or other new findings.
Servus
Karl
************
Access News
Access DevCon- BillCQFeb 07, 2022Copper Contributor
Suggested workaround worked on Friday, not today. Only known "change" was a PC restart. Likely something else changed too, don't know. Tried removing and re-adding trusted locations, has not helped. Also don't know if we have AMSI enabled, have question in with IT.
UPDATE - Restarted PC, workaround again seems to be working. Makes very little sense to me.
- DavideGDFeb 03, 2022Copper ContributorWhat about downgrading runtime versions?
Ciao
Davide- GommacriFeb 03, 2022Copper Contributor
Downgrading Office 365 to previous version solved
- error 3048 cant open any more databases
for me!
I didn't try for Run-time version
Thanks a lot
Cristian- Tiger7663Feb 07, 2022Copper Contributor
@lease forward instructions on how to revert to previous Office 365 version. Thanks.
- Feb 03, 2022
Ciao Davide,
I've never done it myself. So, if somebody has been successful with the Runtime, please report/confirm it here for others.
Personally I would assume the same procedure as desribed in the linked articles also for the Runtime, i.e. with
TargetVersion="16.0.14729.20260"
I would expect to revert the installation back to the previous build of the Current Channel.
Servus
Karl
************
Access News
Access DevCon- DavideGDFeb 03, 2022Copper ContributorI tried the procedure with the target version "16.0.14729.20194".
It worked fine on every full version, but nothing changed on runtime versions, they still remain 16.0.14827.20158...
I'm searching for any solution
Ciao