7 Fixes To Resolve Can’t Close Access Database Issue

7 Fixes To Resolve Can't Close Access Database Issue

Trying hard to shut down your MS Access application but Access won’t close?  Deeply searching for the reasons because of which your MS Access doesn’t shut down?

If you are undergoing this can’t close Access database issue but don’t know how to fix this off then go through this tutorial.

As today through this post, I am going to share some best fixes to resolve MS Access doesn’t shut down.

For a more clear idea about this Access won’t close problem have a look over one such user’s query?

Practical Scenario:

I have an application that is split into a backend and frontend. Running Access 2003 but the application is formatted as A2K. Using WXP Pro.

I make several selections to the BE DB to retrieve records, but have checked and have closed all db connections and set the db to nothing before I leave the subroutine.

I have a button on a form that asks if they really want to leave the application. If they say yes I do have tried Docmd.Quit and Application.quit.

Nothing seems to shut Access down without going into Task Manager and ending the MSACCESS.EXE task.
Any help would be appreciated.

Thanks

source: https://www.toolbox.com/tech/oracle/question/ms-access-doesnt-shut-down-when-i-quit-the-application-012508/

About Access Won’t Close Issue:

MS Access doesn’t shut down is one of the most common problems faced by MS Access users. Mainly when the Access database freezes or crashes very frequently. Well, the main reason behind this Access crashing is your damaged Access report.

Access Won’t Close issue can occur in any MS Access version and in any situation like at the time of opening/closing Access files or when working with access reports.

But have you ever thought why such things happen? Why all of a sudden your Access database doesn’t shut down even when everything is going perfectly fine.

Let’s find the answer to this question first…!

What Are Reasons For Access Won’t Close Issue?

Some most common reason behind Access database doesn’t shut down includes:

  • Corruption Of Access Database:

Corruption of either complete Access database file or any specific report can cause it to get crash at the time of launching. In such a situation neither you can close your Access database nor you can perform any activity on it.

  • Process MSACCESS.EXE Got Hanged:

The presence of erroneous code in the Access report leads the process MSACCESS.EXE to get hanged. This is also one of the major reasons why Access won’t close after opening.

  • Confliction With Anti-Virus Program:

MS Access application confliction with the anti-virus program is also one of the prime reasons. However, the Access database not responding while you are attempting to close it.

Now that you know what’s actually making a problem to close Access database application. So it’s time to move onto our next section i.e how to fixMicrosoft Access keeps won’t close” issue.

How To Fix “Microsoft Access Won’t Close” Problem?

Here I have listed down some best applicable fixes to fix can’t close Access database issue. Let’s start with the simplest one….!

Fix 1. Prevent Confliction Of Anti-Virus Program:

At the time you are working with the Access database stop execution of the anti-virus program.

Meanwhile working with your access database also tries disconnecting the internet. But after finishing up all the work in the database don’t forget to turn on the anti-virus and internet.

Fix 2. Decompile And Recompile Access Database

In this method, you have to first decompile your Access database and after that recompile it again. Follow the steps to perform this task:

  • Create the shortcut which will load your Access database with “/decompile” switch.
  • After making double tap on the shortcut, press the Shift button. This will skip the auto-runs process and will take directly to the navigation window.
  • Once your Access database gets loaded tap to the button “Compact and Repair”.
  • Keep the shift button pressed as the database gets reload.
  • It’s time to compile the code and then save it

After performing these steps, check whether the Access won’t close problem still persists or it is resolved now.

Fix 3# Unhide The Hidden Close Button

Chances are also that your access database close button is disabled. Mainly such a task is performed to prevent a user from closing up the Access database accidentally without saving. MS Access offers the creation of the different types of events on the reports and forms for easy handling of the database.

If the tab is kept hidden then on the Access application you won’t get the Close button (X). In that case, you have to create your own “CLOSE” button for closing up the objects. Don’t forget to, instruct your user for pressing the CTRL+F4 button to close Access database.

If you want to close Access database form but it’s not closing then put the following ‘OnClick’ event in VBA:

myOKtoClose =  MsgBox “Use the Form -> Close option to close this form” Me.Visible = True End If End Sub

After applying this event in VBA, when you tap to close the Access Applications before that the active form will get closed. If the Access database fails to close the form due to this technique then Access won’t close by itself.

Fix 4# Check Your System’s Memory Usage

If you are experiencing this Access can’t shut down problem in some particular PC then the reason can be the low memory issue.

You can also use the memory usage checker app meanwhile your Access database usage. This kind of tool also helps you to establish stability in your PC by preventing the unnecessary load in your PC.

Fix 5# Remove Binary Data from Reports

If you are facing this Access won’t close the problem in the single report on different PC. In that case, chances are high that your Access database has some corrupt binary data. So you need to remove that binary data from your report. Here is how it is to be done:

  • Save your problem showing the report in the text format.
  • Now your report in the Notepad
  • You have to delete the “Checksum=” line and remove the binary data.

Search all the line that starts with the words “Parameter = Begin” and ends with the word “End”. You have to delete all lines from Begin to the End.

Besides that you have to delete parameters such as PrtMip, PrtDevNames, NameMap, PrtDevModeW, PrtDevNamesW, PrtDevMode etc.

  • Scroll through the complete file and look for the VBA code also. If it’s there just delete it.
  • After that save your file and then load your report back within your Access database through the Application.LoadFromText option
  • Now execute the decompile process. After that follow the Compact & Repair process followed with the Recompile option.
  • Try to reopen your Access report and hopefully this time everything works fine.

Fix 6# Remove OLE Object Fields

Sometime problems like can’t close Access database also accused due to the presence of images or OLE object fields within the database.

For storing up the image data, it’s better to store the filename and then save your actual image onto the standard location.

After completing this, you need to rebuild the complete database from the scratch level. Though it will consume lots of time but at the same time, it will give your Access database a fresh start.

Fix 7# Repair Access Database

If all the aforementioned techniques fail to work or if you don’t have that much time to perform manual solution.

In that case, repairing up your Access database using a reliable tool like Access Repair N Recovery is a great option. This tool helps you to fix can’t close Access database issue and its associated problems.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB, $79 USD), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

You can completely rely on this software. You can also try the free trial version of this software before making a purchase. this tool very efficiently repairs and recover MDB/ACCDB file easily.

Steps To Use MS Access Repair and Recovery Tool

Final Thoughts

All the above-listed fixes will surely help you to fix Access won’t close problem so try them fearlessly.

As the bonus tips, I always recommended you all to keep proper backup of your Access database. Apart from that also try to avoid using complex reports or forms in your database.

Look for some better alternative approaches to insert images in Access database and putting binary data in the report. This will, ultimately help you to keep your Access database from getting stuck. To deal with severe Access database problems and issues I have also suggested trusty software.

Try it, if you are dealing with such…!

tip Still having issues? Fix them with Stellar Repair for Access:

This software ensures seamless repair & recovery of ACCDB & MDB database and restores all objects including tables, reports, queries, records, forms, and indexes along with modules, macros, etc. Fix Microsoft Access issues now in 3 easy steps:

  1. Download Stellar Access Database Repair Tool rated Great on Cnet.
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Avatar

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.