none
APPCRASH in Office 2016 (Office 365) Windows 7 Professional RRS feed

  • Question

  • Hello:

    I'm getting a bizarre crash when I try to compile my VBA.  It says that "Access has stopped working", but it can't find a solution.  This is not a large complex application.  Here's the problem signature:

    Problem signature:

      Problem Event Name:                        APPCRASH

      Application Name:                             MSACCESS.EXE

      Application Version:                           16.0.8326.2076

      Application Timestamp:                     598eafa5

      Fault Module Name:                          VBE7.DLL

      Fault Module Version:                       0.0.0.0

      Fault Module Timestamp:                 58def2a6

      Exception Code:                                  c0000005

      Exception Offset:                                000aa161

      OS Version:                                          6.1.7601.2.1.0.256.48

      Locale ID:                                             1033

    Additional information about the problem:

      LCID:                                                     1033

      skulcid:                                                1033

    Any ideas?

    Thanks,

    Rich Locus


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Tuesday, September 5, 2017 10:14 PM

Answers

  • Have you tried decompiling?

    Have you tried importing everything into a new blank db?

    Have you tried an Office Repair?

    If none of the above works, you could make a copy of the db, and then remove a module at a time and compile to identify the source.


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by RichLocus Wednesday, September 6, 2017 3:28 PM
    Wednesday, September 6, 2017 1:48 AM
  • Hi RichLocus,

    Would you get this issue once you compile VBA for any database? Would you get this issue when you try to compile VBA for Excel Workbooks?

    Whats the code in your database?

    It looks like a similar issue in access 2010 sp1

    https://support.microsoft.com/en-us/help/2625046/access-2010-crashes-after-you-install-office-2010-service-pack-1--and

    However, I does not find update for office 2016, maybe you could try to decompile and recompile the database.

    Here are these steps.

    1.Make a copy or backup of your database.

    2.On the computer that is exhibiting the problem, decompile the database. To do this, at a command prompt, run the following command where c:\folder\test.accdb is the path of your database together with the database file name:

      c:\folder\test.accdb /decompile

    3.Close the database.

    4.Open the database in Access 2010 SP1.

    Besides, it seems that you are using Office2016 build 8326.2076 and last version is 8326.2096. I would suggest you update to last version and then test if you will get the issue.

    Best Regards,

    Terry

    • Marked as answer by RichLocus Wednesday, September 6, 2017 3:28 PM
    Wednesday, September 6, 2017 5:52 AM

All replies

  • Have you tried decompiling?

    Have you tried importing everything into a new blank db?

    Have you tried an Office Repair?

    If none of the above works, you could make a copy of the db, and then remove a module at a time and compile to identify the source.


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    • Marked as answer by RichLocus Wednesday, September 6, 2017 3:28 PM
    Wednesday, September 6, 2017 1:48 AM
  • Hi RichLocus,

    Would you get this issue once you compile VBA for any database? Would you get this issue when you try to compile VBA for Excel Workbooks?

    Whats the code in your database?

    It looks like a similar issue in access 2010 sp1

    https://support.microsoft.com/en-us/help/2625046/access-2010-crashes-after-you-install-office-2010-service-pack-1--and

    However, I does not find update for office 2016, maybe you could try to decompile and recompile the database.

    Here are these steps.

    1.Make a copy or backup of your database.

    2.On the computer that is exhibiting the problem, decompile the database. To do this, at a command prompt, run the following command where c:\folder\test.accdb is the path of your database together with the database file name:

      c:\folder\test.accdb /decompile

    3.Close the database.

    4.Open the database in Access 2010 SP1.

    Besides, it seems that you are using Office2016 build 8326.2076 and last version is 8326.2096. I would suggest you update to last version and then test if you will get the issue.

    Best Regards,

    Terry

    • Marked as answer by RichLocus Wednesday, September 6, 2017 3:28 PM
    Wednesday, September 6, 2017 5:52 AM
  • Daniel and Terry:

    Thanks for your suggestions.  I did a decompile and have not had the problem since then.  If it reoccurs, I will upgrade to the latest release of Office 2016.  The strange part is that it was a brand new application and had very little code.  I was running this on two instances: Instance 1 had linked tables.  When I moved the application to instance 2 (where those linked tables didn't exist),  the VBA compile failed on that instance even though I didn't reference the missing linked tables.

    Thanks,

    Rich Locus


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Wednesday, September 6, 2017 3:33 PM