By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,872 Members | 2,333 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,872 IT Pros & Developers. It's quick & easy.

Error message on only one computer in network

P: n/a
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.

Aug 8 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
Aug 8 '06 #2

P: n/a
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.
Aug 10 '06 #3

P: n/a
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

Aug 10 '06 #4

P: n/a
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
Aug 14 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.