none
APPCRASH exception Code c0000005

    Question

  • Hi

    An Access app which was running perfectly has suddenly started crashing with exception code c0000005. Full details of exception below. What is the problem and how can I fix it?

    Thanks

    Regards

    Problem signature:
      Problem Event Name: APPCRASH
      Application Name: MSACCESS.EXE
      Application Version: 9.0.0.3822
      Application Timestamp: 38b692f2
      Fault Module Name: dao360.dll
      Fault Module Version: 3.60.9756.0
      Fault Module Timestamp: 49246e49
      Exception Code: c0000005
      Exception Offset: 00069ed6
      OS Version: 6.1.7600.2.0.0.305.9
      Locale ID: 2057
      Additional Information 1: 3c9f
      Additional Information 2: 3c9fffcafd4a169baa105a8ba17430a7
      Additional Information 3: 5d87
      Additional Information 4: 5d870f90b5f77064f3eaaa19259e5a01

    Sunday, May 05, 2013 1:54 PM

All replies

  • Hi

    I have narrowed down the cause of crash to the first line of below code.

    Thanks

    Regards

    For Each tbl In CurrentDb.TableDefs 'This line causes crash
      tblName = tbl.Name
      If tblName Like strMask & "*" Then
        If (tbl.DateCreated < dDate) Or (ConsiderDate = False) Then
          sq = "DROP TABLE [" & tblName & "]"
          CurrentDb.Execute sq, dbFailOnError
        End If
      End If
    Next tbl
    



    • Edited by Y a h y a Sunday, May 05, 2013 2:06 PM
    Sunday, May 05, 2013 2:04 PM
  • Based on the Application Version, you'd be running Access 2000, but it is not up-to-date.  The first thing to do is install Service Pack 3.  You should be doing any work on a database until you are running a fully patch installation.


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

    Sunday, May 05, 2013 5:59 PM
  • Does you VBA code compile?

    Can you post the complete Function and how you are calling it.


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

    Sunday, May 05, 2013 6:00 PM
  • Hi

    There were a lot of temporary tables generated by the app over time. Once they were deleted, app went OK. I suspect there may be a limit on the number of tables within a db?

    Thanks

    Regards

    Sunday, May 05, 2013 6:40 PM
  • checking help for 'database specifications' doesn't give a maximum for tables other than open tables (2048) and a maximum object count of 32768.

    You might check some of the sizes of your objects against the table list.


    peter n roth - http://PNR1.com, Maybe some useful stuff

    Monday, May 06, 2013 3:00 AM