MS Access Multiuser - Acces2000 Module not found

Author

Acces2000 Module not found

JJoe

2005-04-06, 8:06 pm

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

Scott McDaniel

2005-04-06, 8:06 pm

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.

"JJoe" <javajoe007@hotmail.com> wrote in message
news:vMCdndg_-Jwj987fRVn-pA@rogers.com...
>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
>
>

JJoe

2005-04-06, 8:06 pm

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
____________________
____________________
_
"Scott McDaniel" < scott@NO_SPAM_HEREth
edatabaseplace.net> wrote in message
news:FPednd0sW9RVUc7
fRVn-pg@comcast.com...
> 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.
>
>
> "JJoe" <javajoe007@hotmail.com> wrote in message
> news:vMCdndg_-Jwj987fRVn-pA@rogers.com...
>
>

Sponsored Links