MS Access - Compiled after 1st for does not load anything

Question

MS Access - Compiled after 1st for does not load anything

Phillip J. Seaman 0

I have an application that I have worked on for some time and I am at the stage of distribution and I have a strange issue...
Compile - Success
frmLogin - success

frmMainMenu - Fails to load
the mani menu for loads correctly when I run the code but it will not load in the compiler mode.

' 7. Load frmMainMenu

DoCmd.OpenForm "frmMainMenu"

logMsg = "frmMainMenu opened"

TraceLog logMsg, "INFO"

What am I missing?

George Hepworth 23,120 Reputation points Volunteer Moderator

2026-02-21T12:15:15.2533333+00:00

Please explain what you mean by "the compiler mode". My guess is that you are talking about an accdE created from the accdB, which you would use for distribution.

Before investing, though, in suggestions, I want to be sure we have the full picture of the problem.

2 answers

Your answer

George Hepworth 23,120 Reputation points Volunteer Moderator

2026-02-21T12:15:15.2533333+00:00

Please explain what you mean by "the compiler mode". My guess is that you are talking about an accdE created from the accdB, which you would use for distribution.

Before investing, though, in suggestions, I want to be sure we have the full picture of the problem.

Answer 1

It seems like you are encountering an issue where the form frmMainMenu fails to load in the compiled version of your application, even though it works correctly when running the code. This could be due to several reasons:

Corrupted Form: The form might be corrupted. You can try to recreate the form or import it into a new database to see if that resolves the issue.
Missing References: If there are missing or broken references in your project, it can lead to issues when loading forms. Check for any missing object libraries or type libraries by going to the Visual Basic Editor, clicking on Tools, and then References. Look for any items marked as MISSING and resolve those references.
Errors During Load: There might be unexpected errors in the form's code or design that prevent it from loading. You can check the log files created by Visual Basic for more details about any errors that occurred during the load process. Sometimes, minor issues like a missing version number can be ignored, but others might be critical.
Form Name Conflicts: Ensure that there are no naming conflicts with other forms or controls in your application. If the form name is already in use, it could prevent it from loading properly.

If none of these solutions work, consider checking the specific error messages you receive during the load process for more clues on what might be wrong.

References:

Answer 2

Update (23 Feb): The user has confirmed that the issue has been self‑resolved in a private message.

Hello Phillip J. Seaman, thank you for reaching out to the Q&A forum and I apologize for the delayed response.

First, I recommend reviewing the AI-generated response on your post as it offers some helpful insights that align closely with my own thoughts on the issue.

Additionally, I’d like to point out that recent updates to Microsoft Access have introduced tighter security around SQL queries that reference external databases. This change may be contributing to the behavior you’re seeing. I recommend reviewing the following article to determine whether it applies to your scenario: Query Reference to Remote Database Fails.

Note: This information is provided as a convenience to you. These sites are not controlled by Microsoft, and Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please ensure that you fully understand the risks before using any suggestions from the above link.

You may also want to try importing all objects into a new, blank ACCDB file (External Data > New Data Source > From Database > Access), then recompiling the database and creating a new ACCDE file.

I hope this information is helpful. If the issue persists, please feel free to send your file to me via private message so I can help investigate it further.

User's image

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.