Access 97 runtime app - "Compile Error in Hidden Module:XXXXX" at startup

Posted on 2006-04-13
Medium Priority
Last Modified: 2008-03-04
I developed an application on a Win 98SE machine in Access 97 and used ODE to create a runtime version.  I have about 50 applications installed and all was well until yesterday (04/12/06) and I began receiving calls from all over the country that when user tried to start up app they got subject error message and could not open program.
It seems odd that 10 people on the same day and today and in totally different parts of the country have the same error on an app that has been running for years.  All of these 10 users are using WinXP with, of course, the Access 97 runtime environment with no other versions of Access present.
Sonny Tatum
Question by:SonnyTatum
LVL 27

Accepted Solution

jjafferr earned 500 total points
ID: 16451062

There might be a missing reference,
not all OS have the same references, for example DatePicker ActiveX control.

so you will have to make sure all your References are in the same place for all PCs.

LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 16452579
If your application has been running fine up to that point, you can try to determine if anything has changed on those machines. Are they set to automatically update from Windows? If so, as jaffer mentions, something could have changed that "broke" your runtime installation. Also, if they installed any version of Office or Access on their machine this coudl break your installation.

This can also happen for various reasons:

Have you tried re-deploying to these users?

It is odd that the same thing happened to scattered users around the country ... first thing I thought of was a virus that somehow got included into your runtime or .mdb/.mde file, but that would certainly have been picked up by their antivirus protection (assuming they're running it, that is).

LVL 38

Assisted Solution

puppydogbuddy earned 500 total points
ID: 16455352
I think this excerpt from your narrative:
<All of these 10 users are using WinXP with, of course, the Access 97 runtime environment>>
may be an indication you need to troubleshoot Windows XP,  especially if the 10 users are the only ones with Windows XP.  see XP troubleshooter at the following link:



Author Comment

ID: 16455647
Thank you for your answers....I will go to work and double-check the 5 references in the application.  I did check them on one machine, but it could be that a Windows XP update overwrote one of the references with a new file that is incompatible with my Access 97 runtime.
My problem is that I cannot replicate the problem here.
This has ONLY affected runtime version...all those clients with full version of Access 97 are unaffected.
LVL 58

Assisted Solution

harfang earned 500 total points
ID: 16463518
> All of these 10 users are using WinXP

There has been an automatic WinXP upgrade, the 12th or 13th. If it had anything to do with VB at all, that could be the cause.

I know this isn't helping you in the least, as Access97 does not allow signing of VB code or any of the "advanced" toys M$ is trying to promote. If you are lucky, it would be enough to just regenerate the MDE on a patched WinXP machine...

Anyway, I'm quite confident that you can reproduce your client's bug by using a plain WinXP machine with automatic updates turned ON.

Good luck!

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

850 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