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?
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 220.127.116.1122
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
I have narrowed down the cause of crash to the first line of below code.
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
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.
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