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 (Version 2201 Build 16.0.14827.20028) 32-bit."
I think I got the update around Feb 1 or 2 2022
Observed Errors:
1. MS Access table-handling automation via VBA is failing after 255 calls to Set a Recordset object. The associated error message is "error 3048 cannot open any more databases." This occurs regardless of the appropriate cleanup statements which are in place to close and reset the recordsets to nothing.
2. A ghost image of MS Access persists in memory after the Access application is closed. This prevents any further database from being opened until the ghost application is removed through the task manager.
3. At times an error message is displayed as the current database is closed stating that another database is open. The message is "You attempted to open a database that is already open by another user, 'Admin'... " This seems to occur upon closing a database that failed with the error 3048 (noted above) AND when the database is set to compact on close.
4. The Find and Replace dialog form provided with the VBA IDE for both Access and Excel automatically moves to the Screen(0,0) location each time any of the action buttons are pressed (Action Buttons = Find, Find Next, Replace, Replace All). This issue does not seem to occur in the VBA IDE for my instance of Powerpoint, Outlook, and Word. This might seem to be a petty complaint but the Screen(0,0) location frequently obscures useful controls.
I am currently using Windows 10.
Does anyone have insight into this problem? Does upgrading to Windows 11 fix this?
6 Replies
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?
I'm having exactly the same isuue - same ver. I have just completed a long support session uninstalled/installed Office 365. Unresolved. Same time frame - everything.
You can "end task" in the Task Manager and then delete the locking file. Office support thinks it's a Windows issue. Who knows.
It's good to know others are impacted. I will let you know if I figure out anything.
Robert
- Thank you, George.
This moved my efforts forward a stride or two but leaves the 'Find and Replace' issue unsolved and perhaps off the radar. Can I ask if you experience the problem in which the Find&Replace form in the VBA IDE jumps to screen(0,0)? It might be caused by an unknown setting that I tripped. If you do, it may be an implementation problem that ought to be reported to the Access dev team...something I know nothing about. Any thoughts?- Unfortunately, I haven't seen that particular problem. I assume by Screen(0,0) that you mean the upper left corner of the screen? I wonder if there is any timer event running in a form when this happens. It can be interfering with the keystroke processing. That I have seen although with different overt symptoms.
