Compile Error in Hidden Module: Form_XXX Random Occurance

[MarrowGenx]

I have created a Database Application using Access 2000 and VBA, but it does not seem to work on all computers. About half of the computers I have had it tested on receive the following error:

Compile Error in Hidden Module: Form_XXX

I understand that part of the reasoning behind the error is that I have the VB code locked and the "real error message" does not appear.

I was wondering why an Access Database with VBA code has different reactions to different computers and if anyone has any idea how to eliminate this problem. I appreciate any help that you may have for me. Thanks.

Marrow

 

[Rolliee]

Check to be sure the computers are not using '97. If you are using an mde as you imply, I would also look there. I have problems with 'mde's. I use a front end / back end to get around this. Lock the front end with it's code and leave the back as an 'mdb.' and link the FEs to the BE.

Rollie E

 

[mdav2]

I got a similar message when creating an MDE file:

"Compile error in hidden module: Form_formname"
"Microsoft Access was unable to create an MDE database"

This error occurs because it finds some code that cannot be compiled.
However the error doesn't tell you what exactly is causing the problem.
The error message will tell you what form or module is causing the error.

If you can't see this module or form it may be hidden.
To view a hidden form or module do the following:

Open the database
Choose TOOLS, OPTIONS from the menu bar
Select the VIEW tab
Tick the "hidden objects" checkbox

Now open the module or form.
If opening a form choose VIEW, CODE from the menu option to view the code.
Now choose DEBUG, COMPILE ALL MODULES from the menu bar.

This will then give you the error message and show you which line is incorrect.