Search results

Thank you all. I will try to see the next time I encounter this error.

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.

Thank you. I will soldier on.

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...

No. I only have four forms. None has the ability to prevent another from closing. And this problem only happens sporadically.

Office 365 - current update

But it should disappear on closing the database, right? But sometimes it stays open.

I have tried compact & repair. Do the switchboard controls also follow if I import everything to a new database?

It is a simple database. Can't understand why it does not close properly sometimes.

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.

The last time I'd checked the Task Manager, there was no Access running.

Windows 11 Version 23H2

Thank you. How do I check the Notification status in Access?

My Access database sometimes will not open when you click. Right mouse click to open also becomes unresponsive. When I restart the PC, then it will open on clicking, but only for a few times. Thereafter, it just becomes unresponsive again without any error messages. Keep restarting the PC to...

Thank you LarryE. I will go away and understand the relational model in greater depth by doing some courses. I am hoping to do some VBA lessons by Dec. I will construct the database from scratch and may post problems encountered here in the future. I wish you well and thank you.

I appreciate everyone's help. I want to apologize for not disclosing that I have limited knowledge of both the relational model and VBA. I plan to improve in these areas in the months to come and rebuild the database from scratch. Additionally, I've been advised to stop using the switchboard...

I may have to find time to re-construct the entire database. Do you think the single table format is the reason why DMax doesn't work on certain date-of-birth matches?