compile error in hidden module

[bigreddummy]

i am a hardware pc tech trying to help a userr with an Access problem. She
is using PAS Reporter and trying to open results of a query in Zone Entry and
Time In Zone Calculator. I know nothing about this, but a Microsoft Visual
Basic error message pops up stating "Compile error in hidden module:
Form_PAS_Zoneentrycounter. What does this mean and how can i fix it?

Thanks,
Phil

 

[Jerry Whittle]

The first and most important thing to do is make a complete backup of that
database file and put it in a safe place. Hopefully there are already some
recent backups available as, in a worse case, you may need to use a backup.

Next open the database. Then press Ctrl + g keys at the same time. That
should bring up the VB window. Next go up to the menu to Debug. The first
line on the dropdown should say Compile (the database name). Click on it.

Two things could happen then.

#1: The database compiles fine and dandy. This will happen if you've lead a
good, clean life. Therefore you proably need to check out the next one. ;-)

#2: It will produce an error message. Hopefully this message is more
descriptive than the first one. Write it all down and post back here.

 

[bigreddummy]

Thanks Jerry, your instructions are impeccable. I made a copy so we can do
whatever we want to it. Unfortunately, compile is greyed out. There doesnt
seem to be any data in there, but im not sure what its supposed to look like.
Any further help you can give me would be great.

 

[Jerry Whittle]

If it's greyed out, Access thinks that everything is compiled. Of course the
error message said that something isn't. Not good. Do you happen to have a
recent backup before this problem started? You may need it.

There is a way to decompile the database then recompile it. This depends on
the version of Access. Below is information on decompiling from Tony Toews:
http://www.granite.ab.ca/Access/decompile.htm

If that doesn't work, there's a good chance that the database is corrupt.
Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp