MS Access cannot run the macro or callback function

AnnetteDavid
AnnetteDavid used Ask the Experts™
on
I have a split database self installed at a clients premises.  They are a large company with above average security on their networks.    They have been running the database for a couple of years with 5 users split with a BE and FE.  They have now added some more users and every now and again (getting more and more frequent) the FE seems to corrupt and they get the following message;

MS Access cannot run the macro or callback function "On Ribbon Load", make sure the function exists and take the correct procedure.

Any help would be appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Can you confirm that all users have their own copy of the front-end?

Are all users using the same version of Access and is that the same version that you used to develop the app?  (I'm just wondering about references).

Author

Commented:
Going to double check this now, will come back asap, makes total sence.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
...and verify same OS and Service Pack levels for all machines

Author

Commented:
Have found out that they are running Access 2007 and 2010, so upgrading as we speak, asking everyone to check OS and Service Packs as well, thanks so much, will report shortly.
Then it sounds to me that it could well be a references issue .  I'm guessing that you used A2007 to develop - otherwise you would be reporting that (some) users couldn't open the database.  I think you have to set a MS Office reference to use custom ribbon functions - is that the case, anybody - and I don't know whether Access would automatically update the reference in A2010 to Office14 from Office12.

Author

Commented:
Database was originally writting in Access 2003, then upgraded to 2007 and then recreated in Access 2010.  l would love to know how we could automatically update the reference from office 12 to 14.  Quite a few of our clients we find upgrade to Office 2010 but often just the standard office and leave Access 2007 running as they havent bought the 2010 professional.  I often have to sort references out for these or do an office repair but as I cant get at this database it is so difficult to know how to handle this.  We use no features in the database that are purely for Access 2010.
No News yet back from client,they do take a long time to come back to me but I will update this as soon as i know - again many thanks everyone

Author

Commented:
I have no direct feedback from client as to what solved the problem (apart from the fact that it is solved), but had asked him to do all of the above and there now seems to be no more problems, thank you very much all for your assistance

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial