Compile Error in hidden module...

[Mickeyncube]

I have a user that uses an MS Access database from an NT4.0 workstation. Everytime she tries to access the database from the network the following error comes up

Compile Error in hidden module. Converted Macro - Autoexec. it's got a caption that reads Microsoft Visual basic.

The database works fine with other NT4.0 users. I cant find any diffrence between the working one and no working.
I've tried detect & repair. Is there anything I can do.

 

[nat1967]

HI Mickeyncube,

its sounds as if the database has some vba code that isnt compiled. if its not compiled, every time you open the database, it tries to complie so it can run. time consuming and can cause problems.

is this a .mdb file? do you have full access?

if so, try this:

start the database, go to the code window: (alt + F11), at the top select "debug>Compile Database".

this will do one of two things. it will either compile the database or show you were the code is broken. hopefully, it will compile and take care of your problem. if it breaks, cut&paste the code that broke back here. maybe we can figure out what the problem is and get ya running.

HTH

Have A Great Day!!!,

Nathan
Senior Test Lead

 

[Mickeyncube]

Thanks for the quick response

When I Click on Debug > the Compile data Option is greyed out. The batabase developer has left the company and nothing has been documented about the database.

The Compile data Option is also greyed out for users that have the working database.

 

[DonQuichote]

My first impression is that there is a reference to an external component (DLL) which is present on all machines except for the one that gives the message. When in the debug window or in a code window, select tools > references to see which references ther are in the database.

If all else fails, decompile the database before compacting it and compiling it again. For how to decompile an MS-Access database, look at:

http://www.trigeminal.com/usenet/usenet004.asp?1033

There is a way to get hidden modules that stay active(!) for a while. An existing module could be deleted with "cut" instead of delete. This causes Access to remember the module for pasting as a hidden module.

Best regards

 

[nat1967]

HI Mickeyncube,

greyed out?... hmmm... that usually means one of a few things. 1) the database is fully compiled. 2) the dev that put the database out gave you a mde version. can you see any of the module code? or is it all blank? 3) exactly what DonQuichote stated about a missing DLL.

Good luck.... hope our suggestions point to what you need.

Have A Great Day!!!,

Nathan
Senior Test Lead