12 Ways To Troubleshoot Microsoft Access Crashing issue When Opening Report

Does your Access Database frequently being crashed every time you tries to open up your Access report within it? You might be worrying why this issue is been arising or how to stop this Microsoft Access keeps crashing issue quickly.

Well, this particular post addresses such troubleshooting ways that works great to prevent Access database keeps crashing.

Practical Scenario:

Good day,

Since this afternoon – about 10 hours ago – MS Access 2016 crashes whenever I try to run a report. I worked on it before 10 o’clock without any problems. Then I switched my computer off for 2 hours. While switching it off, some updates were installed. When I switched it on just after 12, it started crashing. I have tried a large number of backups that have all functioned fine but to no avail. Anyone of the reports causes Access to crash.

Can anyone help? Please. I need to submit reports tonight still.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_win10-mso_2016/access-2016-crashes-when-opening-reports/3e02829f-4011-47d8-b7c0-01edf83040d8

MS Access Database Crashing When Opening Reports:

MS Access Database Crashing When Opening Reports

Well the Access 2016 keep crashing issue is the most frequent and most frustrating issue faced by most of ms access application users. And this issue can encounter at anytime either during closing of Access 2010/2013 files or while working with reports.

Do you know why this happening? Or what’s the reason behind this frequent MS access application crashing?

What Are The Reasons For Access Database Crash?

Reasons For Access Database Crash

have a look over some most common causes for Access Database Crashes When Opening Report :

  • presence of  invalid or wrong code in the Access report makes the abrupt termination of MSACCESS.EXE.  
  • Sometime conflicts between the anti-viruses programs which is running on the PC can also causes such Microsoft Access crashing.
  • May be the report inside the database somehow get corrupted which causes it to crash while accessing.

How To Resolve The “Microsoft Access Keeps Crashing” Problem?

Microsoft Access Keeps Crashing

Starting with the simple solution, here is all that you can try to fix Access keeps crashing issue.

1# Decompile And Then Recompile The Database

You can also opt for decompiling and recompiling of the database. And you need to try the following steps for performing this.

  • Make a shortcut which loads the your database with “/decompile” switch.
  • Keep pressing the Shift button when making a double tap on to this shortcut for skipping out the run step. now you can go straight into navigation window.
  • Finishing up the complete loading of the database, tap to the option “Compact and Repair”.
  • Once again keep pressing the Shift option. As this will reloads the database.
  • It’s time to compile your code and then save it.

After performing the complete task just check out whether the problem still persists or get resolved somehow.

2# Check Your System’s Memory Usage

If the Access database crashing while opening report is encountered on few specific PC’s only then it can be the issue of low memory space. So, just check out the memory space of your system before working on it.

3# Stop anti-virus program

For some duration at least stop your anti-virus program which you are using with MS Access. You can also close the internet connection while working with the access database in order to avoid the conflicting situation. After finishing up the complete work in your access database you can turn on your anti-virus back.

4# Remove Binary Data from the Access Reports

If the crashing issue is encountered in any specific report even if you tries to open on different system, then it indicates that your binary data present within that report has corrupted. for removing up such corrupted binary data from reports, just try out the below steps:

  • Save faulting report in text file format. After then using the notepad application open the report saved in text format.
  • Remove the line “Checksum=” and then remove off the binary data. After then make a check for lines containing words like “Parameter = Begin” at the beginning and the  “End” word at the ending section.

Delete the entire lines present within the beginning to ending section of these words. Along with that also delete the parameters such as  PrtDevNames,  PrtMip, PrtDevModeW, NameMap, PrtDevNamesW,PrtDevMode etc.

  • Scroll down in the file and fetch for the VBA module code. once you get it just delete it.
  • Now it’s time to file saving after then reload your report again into the Access by making use of the option Application.LoadFromText.
  • After Recompile now it’s time to run Decompile along with the Compact & Repair.
  • Now open your Access report once again.

This time you will see that all things get fixed. If unfortunately this method fails then also don’t lose hope. Give it a try to our next fixes.

5# Remove OLE Object Fields And Then Rebuild The Entire Database

If the report of the database contains images or other OLE objects fields then this can often causes issues like Access Crashing while opening reports.  In case to store the image data, the best way is to store the filename and then save the actual images to a standard location. After doing this, rebuild the complete database from scratch.  This will take more time but this will give your database a fresh start.

6# Import Database Objects Into A New Empty Database

Just check out which report is actually causing this Access Database keeps crashing issue by reading out the crash report or error log.  After knowing that, make a backup of the access database file and then delete that report which is causing the report crashing. After then create a new empty copy of the database and import the entire objects from the old one into it. Recreate the report once again and check that if the problem still encounters.

7# Repair Corrupt/Damaged Access Database

If the entire mentioned manual methods won’t give success. Or when you don’t have that much of time to make complete database rebuild. Then in that case repairing off your Access database using the Automatic solution is the wisest option. So, try the most professional recommended option Access Repair and recovery software  to fix corrupt or damaged Access report..

The advanced scanning and repair algorithms of this software tool, is just perfect to resolve damaged reports and other corruption issues or errors.

8# Remove MS Access Standalone Version

Microsoft access keeps crashing when two different version of the same software is been installed on system. This indicates that your system is facing resource utilization issue. Usually this problem occurs when you have installed any packed version of the software and after then you have installed a standalone version on over it. So, when the resource of your system are been shared across both the installed application software, this will generate unexpected issues like freezing or crashing.

So for this you just need to perform the following tasks:

  1. You need to uninstall the standalone version of MS Access 2010/2013/2016.
  2. Make reboot to your PC for removing out all the software traces permanently.
  3. Start up your MS Access application again and check whether it is stable in its operations or not.

9# MS Access Stop Working When Using Filters With Databases

Mainly this issue of Access database crashing arises when database is not from any trusted location. Because untrusted Access databases hinders the running of macros successfully and thus it results in the Access Database Crashing Windows 10.

  1. Make a check of all the references which are available in the VBA
  2. Also check all the updates for MS Access,whether it is properly installed on the PC and you are running it through Run as administrator option. To run this application from this option, make a right-click on MS Access > More > Run as administrator.

10# Disable Hardware Graphics Acceleration

Another very common reason behind Access Database Crashing in Windows 10 is due to hardware acceleration problem.  Well running the program when the hardware acceleration option is enabled can raise Access database crashing issue.

For disabling this option, at the time of using MS Access application. Follow down the steps:

  1. After opening up your MC Access interface, tap to the File > Options.
  2. Now within the General tab, choose the checkbox for Disable hardware graphics acceleration.
  3. At last tap to the OK option. After making all the changes make a reboot to your PC.

11# Databases Slowdown MS Access In Windows 10

Usage of numerous tables in single database and sometime switching from older version of Windows to newer one also causes poor Access database performance.

So here is how to resolve this issue:

  1. Go to the MS Access executable files location. Well you can find this MS Access folder in this two different locations:
    • C:\Program Files\Microsoft Office\Office14
      Or
    • C:\Program Files (x86)\Microsoft Office\Office14
  2. So open up this MS Access executable file’s properties and go to the Compatibility
  3. Within this Compatibility mode heading, choose the checkbox for Run this program in compatibility mode for.
  4. Choose the Windows 7 from the dropdown menu.
  5. Tap to the OK option and restart the computer.

12# Add Windows 10 Patch To Fix MS Access Crashing

Sometime Access database crashes in windows 10 without any reason; this might be due to loophole in Windows. This issue can be easily fixed just by using the recent updates.  If you are still facing the problem then here is the workaround for you.

  1. Make a copy of Access database.
  2. Open up your Command Prompt as an administrator.
  3. now run the following command:
    <path to database file> /decompile ex. C:\test.accdb  /decompile
  4. Close the database and restart your PC.
  5. You can also, install the patch to resolve this issue.

Wrap Up:

Undoubtedly database corruption is worse than a nightmare for Access users. Losing important stuffs due to silly mistakes can be very frustrating. Fortunately, sometime users get lucky enough to repair or recover this data. Sometime third party software tool helps to rescue your database from fading away from existence. However, a better approach is to keep your Access Database aside of this problem just by implementing preventive measures to avoid the corruption.

Further Reading:

How To Fix Microsoft Access “Can’t Create This Relationship And Enforce Referential Integrity” In Access 2013/2016?

How To Fix Access Forms And Reports Not Showing Image Issue

How To Troubleshoot “Access Database Form Opening Blank” Issue?

How To Fix Access Database 3151 Error – ODBC Connection Failed

12 Ways To Troubleshoot Microsoft Access Crashing issue When Opening Report