At least your database eventually open; not in my case. I don't even get the turning circle. In my case, something is preventing it from properly quitting the access app on Exit.
I am a novice when it comes to VBA. I had constructed this basic database some 8 years ago without any use of VBA. That being said, I did incorporate just two VBA codes two years ago. I shall attach those here.
The main form is shown below:
Apologies if these aren't much help. At the moment...
I think I have identified the problem. Occasionally, when I open my database, the temp file with the padlock symbol stays even after I close the database. I have to manually stop the access from the task manager and then delete this temp file before I can double-click to open my database again...
What I meant was when encountering the problem for the first time a couple of weeks ago, when I clicked on Access and it failed to open, I did look at the Task Manager to see what was currently running. Access was not on the list. This has led me to believe that it actually failed to open.
Many thanks. The file type is (.accdb). My database is quite a simple one with little or no VBA code written. Below is the status of the notification.
I will look at the Windows system logs the next time it fails to open as per your instruction.