Access and OLE

[YoungManRiver]

I keep getting this error saying:

"A problem occured while Access was communicating with the OLE server or Active X.

Close the OLE Server and restart it outside of Access. Then try the original operation again in Access."

I can't make it go away not even with a De-Install/Re-Install of Office.

Does anyone know what causes this?

 

[YoungManRiver]

Does anyone know anything about this?

 

[mybers]

What kind of object did you used in your form anyway? an Image?calendar control? etc....

Need more details/explanation...

OLE basically requires a reference to open an object like an image it would usually require ppaint.ocx

pls clarify further....

 

[YoungManRiver]

Problem solved!

Got a post at:

http://forums.winxpcentral.com/showthread.php?p=24635#post24635

Taking me to a windows post at:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q295824

Which addressed this.

Seems NAV Script Blocking interferes with Normal Operation of Access.

 

[Firglisz]

Have the same problem and I'd like to close and restart OLE server but has no clue what to do. Any instructions how to do it?
thanks in advance

 

[YoungManRiver]

Firg,

I you clicked on the second link you'll find you need to disable script blocking in NAV while running OLE in Access.

Then you can turn it back on after running your Access program.

 

[Firglisz]

YoungManRiver,
There's no NAV installed on that PC. Only WinXP and Office XP. Have no info about SPs. So in this case your second link suggest me to close and restart OLE server outside of MS Access but don't know how to do it.
Do you have any idea what to do ?
thanks,
Firglisz

 

[YoungManRiver]

Firg,

Are you running another AntiVirus program?

 

[Firglisz]

YMR,

No nothing. Win XP and Office Pro was reinstalled by me. Nothing else and I still keep getting those message. I'm afraid I had something installed on my home PC where I develop this application and it is being used by Access, while it is missing from other PCs. Do you think this might be the reason ? Is that possible that I send you this small app, and you try to run it on your PC ?

 

[Firglisz]

YMR,

No nothing. Win XP and Office Pro was reinstalled by me. Nothing else and I still keep getting those message. I'm afraid I had something installed on my home PC where I develop this application and it is being used by Access, while it is missing from other PCs. Do you think this might be the reason ? Is that possible that I send you this minimized version application, and you try to run it on your PC ?

thanks,
Firglisz

 

[YoungManRiver]

Firglisz,

If you did your dev on one machine and can't run on another did you check the "References"?

You have to click on modules, in the dev environment, open a module or open code from events properties on a screen item on your dev page ==> This open the VBA code session.

On the VBA code session screen select "Tools" + "References".

The references must be the same or things will go bump.

 

[Firglisz]

YMR,

Issue has been solved !
It seems I had problem with non english Windows XP! As I told you I already re-installed WinXP and Office XP on this PC, did not help. Yesterday I re-installed again but this time I was using english Win XP. Great news, this time application was running smoothly, without any OLE error message. Well, it seems not only NAV or script blocking causing this problem. Good experience...