We help IT Professionals succeed at work.
Get Started

Menu Macro ‘Action Failed’, Access 2003

mlcktmguy asked
Last Modified: 2017-03-14
I got an unexpected error report (twice) today from a user of a long running, stable application. By stable I mean three years full time every day with 40 – 50 users.  No changes were made recently, especially to this area.

I’ve been developing in Access for over 15 years and never encountered this situation.  I used the application specific ‘Main_Menu’ as the Menu Bar on all of the forms in my other applications also.

This application is split and each user has their own copy of the application on their machine, all linked to the backend Access MDB
The macro that failed was ‘Main_Menu’.  This menu appears at the top of all of the forms in this application.  It is defined as the ‘Menu Bar’ on all of these forms.

It failed loading ‘Reports_menu’.
Macro FailureThe failure appeared as soon as the application tried to open the form.

About this Macro
Main Menu has 4 ’AddMenu’ rows, each adding another menu macro.  File_Menu, Action Menu, Reports_Menu and Admin_Menu in that order.
File Menu contains only 1 ‘RunCommand’ row, ‘Exit’.
Action Menu contains 4 rows, 3 ‘RunCodes’ and 1 RunMacro.
Reports_Menu has 5 ‘RunCode’ lines.
Admin_Menu has 27 ‘RunCode’ lines.

I am at a loss as to what could cause this issue, especially twice on one user machine in the same day but not any of the other 49 machines using the Main_menu macro for the last three years.

Any help would be greatly appreciated.

I am providing as much detail as possible but if more is need to resolve this issue please let me know.
Watch Question
Top Expert 2016
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE