Error message on only one computer in network

[yal]

We use several databases on several computers in a small network, and
on a new computer we just bought we get the following message every
time we try to activate any procedure:
"The expression (OnOpen, or OnClick, whatever generated the sub) you
entered as the event property setting produced the following error: A
problem occured while (the name of my database) was communicating with
the OLE server or ActiveX control."
The standard help options of Access do not solve the problem.

[ManningFan]

Make sure the new database has the same version of ActiveX as the
others. Also, open a Module and check the References (click Tools,
then References in the VBA screen) to make sure nothing is missing.

If the code works on all but one machine, the code isn't the problem.

ya*@hakohanim.org wrote:

We use several databases on several computers in a small network, and
on a new computer we just bought we get the following message every
time we try to activate any procedure:
"The expression (OnOpen, or OnClick, whatever generated the sub) you
entered as the event property setting produced the following error: A
problem occured while (the name of my database) was communicating with
the OLE server or ActiveX control."
The standard help options of Access do not solve the problem.

[yal]

Thank you for replying. I should have specified that I tried this
already and the references on all the computers seems identical.

ManningFan wrote:

Make sure the new database has the same version of ActiveX as the
others. Also, open a Module and check the References (click Tools,
then References in the VBA screen) to make sure nothing is missing.

If the code works on all but one machine, the code isn't the problem.

ya*@hakohanim.org wrote:

We use several databases on several computers in a small network, and
on a new computer we just bought we get the following message every
time we try to activate any procedure:
"The expression (OnOpen, or OnClick, whatever generated the sub) you
entered as the event property setting produced the following error: A
problem occured while (the name of my database) was communicating with
the OLE server or ActiveX control."
The standard help options of Access do not solve the problem.

[Rick Brandt]

ya*@hakohanim.org wrote:

Thank you for replying. I should have specified that I tried this
already and the references on all the computers seems identical.

To clarify...

The references are stored in the MDB file so of course you see the same ones
on all PCs. What you have to look at is the description of each "checked"
reference to see if it has the word "MISSING" at the beginning. That
indicates that the external library that the reference points to is either
non-existent, not properly registered with Windows, or is the wrong version.

That is what has ot be corrected.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[yal]

Thank you very much for your answer. Unfortunately I was aware of this
and already checked all the references and they all come up as
functioning.

Rick Brandt wrote:

ya*@hakohanim.org wrote:

Thank you for replying. I should have specified that I tried this
already and the references on all the computers seems identical.

To clarify...

The references are stored in the MDB file so of course you see the same ones
on all PCs. What you have to look at is the description of each "checked"
reference to see if it has the word "MISSING" at the beginning. That
indicates that the external library that the reference points to is either
non-existent, not properly registered with Windows, or is the wrong version.

That is what has ot be corrected.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com