crjo
asked on
OLE server error message
Trying to bind ActiveX control (Microsoft Office Navigation Control 9.0) on form. When I double-click on the control I get the following error message:
"A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control.
Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again inside Microsoft Access."
How do I close the OLE server and restart it? Do I need to register some dll or ocx file?
I've disabled Norton Anti-virus Script Blocking and the Office plug-in.
"A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control.
Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again inside Microsoft Access."
How do I close the OLE server and restart it? Do I need to register some dll or ocx file?
I've disabled Norton Anti-virus Script Blocking and the Office plug-in.
What they mean is: if your ole server is an executable like word or excel you should close the database. Open word or excel open the database and try again. This will often solve a lot of problems since the ole server is already in memory, this is in your case not possible.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Interestingly, I have exactly the same error with this control, both versions 9 and 10. Re-registering it does not fix it - I wonder if it is inherent in the control.
also are you up to date with respect to service packs?
I have no problem, we are talking about the "Microsoft Office RECORD Navigation Control" right?
I do not know how to use it :) but I dropped it on a form and a data access page. I am able to double click it.
I do not know how to use it :) but I dropped it on a form and a data access page. I am able to double click it.
Me or crjo ?
Ah, I tried it in a form inside Access, which is where I get the problem, not a data access page. Yep, the "Microsoft Office Navigation Control".
I also have absolutely no idea how to use it :)
I also have absolutely no idea how to use it :)
Well, having tried it again in A2K2, no errors there...should have probably tried it out there instead of A97 first :-)
So that might be the problem! crjo are yoy trying to use this control in access '97?
yoy should be you
Maybe superfluous but it seems to me that the navigation control is used by access in the navigation section of data access pages and can not be used by us mere mortals.
ASKER
heer2351: I'm up to date on all Service Packs (Office, Windows 2000 - just checked again to be sure). Using Access 2000. Also tried using the control on another box with the Northwind sample db and got the same error. I'll try the unregister/register process and post comment. BTW: I'm also running SQL Server 7 if that means anything.
I've not tried in on A2K, but when I tried it on A2K2, it was disabled.
Not that I have any idea what it does :-)
Not that I have any idea what it does :-)
See http://support.microsoft.com/default.aspx?scid=kb;en-us;208283
The ActiveX control is not on the supported list
Let's try another approach...
What are you trying to accomplish? Perhaps there is another way without using the dysfunctional ActiveX concept.
The ActiveX control is not on the supported list
Let's try another approach...
What are you trying to accomplish? Perhaps there is another way without using the dysfunctional ActiveX concept.
ASKER
dotthei thanks for the link. Here is what I'm trying to accomplish (if possible): I would like to include the Delete, Save and Help buttons on the navigation bar. I know I can have those on the toolbar, but that will be disabled when the db opens. Hope that made sense.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
heer2351 and dotthei thanks for your help. I obviously need to rethink this.