Acces2000 Module not found

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JJoe - 06 Apr 2005 05:16 GMT

I have a situation that I have spent hours trying to figure out with no
success and would appreciate if someone could help me out.

Basically the setup is like this:

A Windows2000 workgroup server hosts three mdb files that can be accessed
from 7 workgroup computers on this workgroup network.

All 7 computers can access two of the mdb files on the workgroup server;
however only six can access all 3 mdb files. One workgroup computer receives
an error message when it attempts to open the file which is cleary visible.

_____________________________________________
"The expression On Open you entered as the event property setting produced
the following error: Module not found.
* The expression may not result in the name of a macro, the name of a
user-defined funtion or [Event Procedure]
* There may have been an error evaluating the function, event, or macro.
OK
_____________________________________________

Does anyone knw of a solution or a hint?

Thanks in advance
JJoe

Reply to this Message

Scott McDaniel - 06 Apr 2005 12:49 GMT

Is this an all-Access application? That is, you're not connecting to access
tables from a VB or C app? If it's all-Access, the you can try to compile:

On the machine where you're having the trouble, open the VB Edit window (Alt
+ F11 will get you there) and click Debug - Compile. Note this must be done
with an .mdb file; if you've converted this to an .mde file you can't do
this.

If the app compiles correctly, and you have another copy of this (like on
one of the other machines), I'd replace the app and restart.

>I have a situation that I have spent hours trying to figure out with no
> success and would appreciate if someone could help me out.
[quoted text clipped - 23 lines]
> Thanks in advance
> JJoe

Reply to this Message

JJoe - 06 Apr 2005 14:23 GMT

Hi Scott,

Thanks for your reply.

This is an all access application.

Funny thing is only one computer has the problem.
I will try your recommendation.. Thank you for the same.

JJoe
_________________________________________

> Is this an all-Access application? That is, you're not connecting to
> access tables from a VB or C app? If it's all-Access, the you can try to
[quoted text clipped - 36 lines]
>> Thanks in advance
>> JJoe

Reply to this Message