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

Posted on 2006-04-13
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


    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 84

    Assisted Solution

    by:Scott McDaniel (Microsoft Access MVP - EE MVE )
    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

    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

    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

    > 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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    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.
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now