BFanguy
asked on
APPCRASH Access 2010 running macros
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What version of Windows - 32 or 64 bit?
Why not convert to VBA? Just so I understand.
Regards,
Bill
Why not convert to VBA? Just so I understand.
Regards,
Bill
I believe it is the 32bit odbc driver locking up.What leads you to this assumption? The error above indicates "olmapi32.dll", which is associated with email.
What does your macro do?
FWIW, running unattended operations which rely on macros is fraught with issues. As BillDenver suggests, convert this to VBA, which allows you to actually manage errors, and you'll resolve this much more quickly.
ASKER
Will try converting to vba.
ASKER
Converted to vba.
Still get:
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
Still get:
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
Then I'd suggest you have issues with your email system, since the "fault module name" is olmapi32.dll. You might try repairing or reinstalling Outlook.
ASKER
Thanks Scott.
I failed to mention, I had reinstalled Outlook after changing from a macro to vba.
I failed to mention, I had reinstalled Outlook after changing from a macro to vba.
ASKER