Last Friday, I installed MS Office Professional Plus 2016 on a Windows 10 PC, after first using an MS tool for removing other Office versions.
I then used Access 2016 to convert an Access mdb database (front and back end files) in 2003 format to the accdb Access 2016 format.
I fixed a few issues (like inserting the DAO prefix where it was missing), I also linked the front end to the back end, and all seemed to work great the day of the installation.
Then the next day, I again opened Access 2016 to make some minor remaining adjustments to my converted database (no code changes, just adjusting colors and tab sizes). Again, everything was fine.
Then Sunday when I opened Access 2016 again, I encountered a problem with MSAccess.exe not closing.
After trying all kinds of things to fix and diagnose the problem, here's what I found:
If I try to open Access 2016 by clicking on my front end accdb in File Explorer, it fails to open. The laccdb temporary file is created, but the Access application Window is not visible on my monitor, nor is the Access application button showing in my task bar.
When I attempt to restart the computer, I get a message saying I have an application open and do I really want to restart? When I cancel, I'm brought back to my desktop with just an Access message box visible that I designed to alert the user they cannot close a form without using the close button I created for it. This form this close button is on, opens via an autoexec macro when ever the database mdb front end file is opened.
While this message box is displayed during the problem, nothing else about Access is visible: the normal Access window is not visible nor is there Access button visible on my task bar.
Nor is Access visible in task manager in the "Processes" tab; but MSAccess.exe is visible in the "Details" tab in task manager.
But I can open the Access application, however that results in two MSAccess.exe's being visible in the "Users" tab.
Also, the laccdb temporary file is still open for the accdb front end I was trying to close. Further, sometimes or always, the laccdb temorary file for the back end database also is still present (I say "sometimes or always" because I didn't know to check during all my tests until I discovered by accident that such a temp file is also created for a back end database as well as for the front end).
When I restart the PC completely, I can then open the accdb front end by clicking on it in File Explorer again.
Deleting the autoexec macro does allow me to open and close the accdb repeatedly without a problem by clicking on it in File Explorer.
BUT, once opened, if I open some forms and close those forms again, the problem recurs.
If I open Access first, then use the "Open" command from within the Access window, I can open the database and open and close the offending (forms), and then close the database again if after I close the form(s) I close everything by closing the Database application.
But if I first attempt to separately close the database file and then seek to close the application window, I find I cannot close the application window.
So far it seems that some code I'm running on some forms might be the problem.
And I'm thinking the reason I had no problem with his the first day after installing MS Office Professional Plus 2016 from a DVD, might be because the problem might have arisen after Office installed updates overnight. And that something in the coded I wrote disagrees with something in an update. (My guess is my code is wrong somewhere, i.e. not that an Access update is faulty)
Any ideas or questions would be appreciated!