Module not found

  • Thread starter Thread starter Svein
  • Start date Start date
S

Svein

When opening a form I get the error message "Module not
found" without any reference to the which module this is.
When pressing OK on the messagebox the visual basic editor
opens - without opening any module or displaying any text,
marks etc.

Any suggestions greatly appreciated!!
Thanks
 
Sounds like the database is partially corrupt.

Try:
Tools | Database Utilities | Compact/Repair

If that does not solve the problem, try a decompile. Close Access, and enter
something like this at the command prompt. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
 
Thanks,- that was fast!

Unfortunatly it didn't work out the problem. The second
solution gave me the erroromessage "unrecognized database
format".

Since my last message I have done some more testing, and
it seems like the use of one specific module in a form
causes the problem. I can't see though that I have used
bad names or anything. DO I need to get back to one of my
backups and do all my work all over again, or are there
other solutions.

Thanks for any answers!

Svein
-----Original Message-----
Sounds like the database is partially corrupt.

Try:
Tools | Database Utilities | Compact/Repair

If that does not solve the problem, try a decompile. Close Access, and enter
something like this at the command prompt. It is all one line, and include
the quotes:
"c:\Program Files\Microsoft
Click to expand...
office\office\msaccess.exe" /decompile
 
This should help you recreate your database in just a few minutes.

1. Create a new (blank) database:
File | New

2. Import everything *except* the problem form from the bad database:
File | Get External | Import

3. Import the bad form from an old backup copy.

For more detailed information, see:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

For suggestions on how to prevent this recurring, see:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
 
Back
Top