APPCRASH Access 2010 running macros
Posted on 2013-11-14
I have a ~300 line macro in Access 2010 that runs nightly that pulls information from from sqlserver 2008R2 via odbc (32bit) and emails ~ 100 different reports.
At least once a week it hangs at different points in the macro with the same "Microsoft Access has stopped working" message (see below). This has been occurring for the past 3 years (since I installed 2010) and have been patching at least once a week (hoping the problem would go away).
Also, I reboot the computer every night before the macro is ran.
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 14.0.7104.5000
Application Timestamp: 51ce12f7
Fault Module Name: olmapi32.dll
Fault Module Timestamp: 522a335e
Exception Code: c0000005
Exception Offset: 002989cc
OS Version: 6.1.7601.2.1.256.48
Local ID: 1033