Access 97 Function Calls from Events stops working

[barnstorm]

Hi Folks

I have a very odd one

I have an Access 97 MDB application. It has all been working fine for over a year - upwards of 10 users.
Suddenly one user starts getting errors.
On investigating I find that event procedures and calls from code are working fine.
What is not working is calls to functions directly from events. They give the "Bloggs.MDB can't find the Macro or Function blah blah blah" as if the name was misspelt. (It is not !) Every other user is working fine. I have got a fresh copy of the mdb. I have recompiled the modules the database on the machine in question.
Then I notice his Access is SP1 - Putting on SP2 fixes everything - he is fine - it all works - until he restarted next morning when the problem came back.
I have tried a noddy database written from scratch on his system and it shows the same faults - seems like it is Access that has the problem not the MDB.
If it is relevant he is using Windows ME - everyone else has Windows 98 I think.

HELP PLEASE!!!

Ian J

 

[tman138]

All of your users must have the same service pack version as the developer for your apps to run smoothly. Removing items such as service packs from Win ME is not fun. You will probably end up editing the registry to remove those entries before reinstalling the correct service pack. Check Microsofts tech support for info on how to accomplish this.

 

[chachidog]

Try msaccess / decompile. Decompile your current application, close it and open a module and compile. Once that is completed, exit the application and reopen it.