Access Closes on Start

Question

All of a sudden my database has started closing immediately on start up.  

It started this morning just fine.  I closed it and opened another database.  Then when I went back to it and it wanted to create a backup immediately.  I created a backup.  After a few attempts at creating backup the application finally opened. 

This is not my master database with all 5000 forms and reports.  If it was then I would suspect that I have exceeded the number of objects allowed by Access. But this database has only 650 forms and reports, and I am running it on a I7.

What is causing this?  Thanks.

Answer 1

There may be hints in the Event Viewer.

You may need to run an Office Repair.

Answer 2

Thanks Madoc,

My database hasn't experienced the problem so far today.  Keeping my fingers crossed that Tom's solution worked.

To answer your questions:

Office Professional 2019

V1909

Build 12026.20334

No error messages appeared, Access just started and immediately terminated.  It then executed a Backup.  

No problem with my master database, just a subset (Lite version).  The Lite version was created from the master - I have 

copied 373 tables, 421 reports into Lite from the master (2635 tables, 2903 forms, 1957 reports).  Accomplished since August 25, 2019.

No 3rd party add-ins.  No ActiveX controls.

This started on Monday, if I remember correctly.  Before then, the Lite version worked just fine.  

David

Answer 3

Thanks Tom.

I executed an Office Repair.  Hopefully, it will work.  I won't know for sure until I reboot in the morning. 

Just in case something went wrong I backed up my databases to two different USB drives.

David

Answer 4

Hi David,

I’m sorry that you’ve encountered this issue.

As Tom said, you can run an Office Repair and check it. Waiting for your results.

Besides, there’re still some suggestions you can have a try:

1. Update Office to the latest version. As Office is updated, some issues will be solved. So it’s a good idea to keep Office up-to-date.
2. Open Access in safe mode to exclude the impact of some third-party add-ins and check the result.

If the issue persists, we’d like to collect some information to further check the scenario:

1. Which version of Office do you have?

You can find version information after opening Access, click on File > Account.

2. Is there any error message? If so, could you please take a screenshot of it and share it with us?
3. Does this issue also occur on other databases?

Best regards,

Madoc

Answer 5

Hi David,

I'm so glad that the issue's been solved by running the Office Repair. Because Access is a part of the Office suite of programs, the Office Repair utility usually works to fix something wrong with Access.

Thank you very much for sharing the detailed information and posting the solution to the public so that it would help those who are experiencing the same problem.

If you encounter any problems in the process of using Office in the future, please feel free to raise them on Microsoft Community. We would do our best to assist you.

Have a good day/night!

Best regards,

Madoc