Forum Discussion
Problems with MS Access and Excel in MSO (Version 2201 Build 16.0.14827.20028) 32-bit
The following problems are manifested in MS Access and Excel ever since MSO365 was updated. The "About Access" screen shows the following build ID. "Microsoft® Access® for Microsoft 365 MSO (Vers...
Making your database location "Trusted" in Access does solve the issue for now. Did for me.
https://support.microsoft.com/en-us/office/access-is-unable-to-close-and-leaves-lockfile-active-b2dce32b-b8b0-41f1-ba40-7876e524d9da
- Robert,
Thanks for the info. Yea. Putting the DB in a trusted location delivers a mixed bag for me. It does eliminate the "too many open databases" problem. But it does not eliminate the persistent ghost app, nor does it solve the problem regarding the Find-and-replace form jumping to screen(0,0) with every keypress. That is probably a small issue for most users but is an annoyance especially if you rely on it during development. On that, frankly, I don't believe it's a problem caused by updates involving AMSI (Antimalware Scan Interface). I am hoping that some insider knows of a setting that I might have tripped. Any ideas?
