Solved

APPCRASH Access 2010 running macros

Posted on 2013-11-14
8
1,052 Views
Last Modified: 2014-12-18
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
0
Comment
Question by:BFanguy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 14

Accepted Solution

by:
Bill Ross earned 500 total points
ID: 39649566
Hi,

I would suggest that you convert the macro to VBA.  Macros do not have any method to trap errors.  You can do that in VBA and solve the issue much quicker.

If that's not an option then break the macro up into multiples and the message on the screen may give a clue as to which one fails.

Regards,

Bill
0
 

Author Comment

by:BFanguy
ID: 39649668
converting to vba is not an option, I believe it is the 32bit odbc driver locking up.
0
 
LVL 14

Expert Comment

by:Bill Ross
ID: 39650879
What version of Windows - 32 or 64 bit?

Why not convert to VBA?  Just so I understand.

Regards,

Bill
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 84
ID: 39650937
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.
0
 

Author Comment

by:BFanguy
ID: 39689856
Will try converting to vba.
0
 

Author Comment

by:BFanguy
ID: 40507033
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
0
 
LVL 84
ID: 40507063
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.
0
 

Author Comment

by:BFanguy
ID: 40507067
Thanks Scott.

I failed to mention, I had reinstalled Outlook after changing from a macro to vba.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question