OLE problem Msg

[Guest]

Hello,
I have problem with unpleasant massage when running access database. Windows
XP was reinstalled on the computer (and MS Office Pro). Each time the form is
opened (by macro) a massage appears as follow:

"A problem occurred while (db name) was communicating with the OLE server or
Active X control. Close the OLE server and restart it outside of (db name).
Then try original operation again in (db name)."

I do not understand this message.
The same references are set on the neighbouring computer (both not connected
to network), where data base is working OK.
I have already tried changing Regsvr32.exe with a new one (from internet)
and run it: C:\Windows\System32\ Regsvr32.exe_library name

We resolved similar problem on third computer by uninstalling Norton
antivirus program. But it does not work for computer mentioned above.
This is a problem that persist for a long time. A year ago I sent the same
question to workgroups. But it stayed unanswered question.

Has anybody the same problem?
Can you help me?

 

[Arvin Meyer [MVP]]

I've seen this happen with the microsoft calendar control. If that may be
the cause, try removing it and replacing with my calendar form:

http://www.datastrat.com/Download/Calendar2K.zip

You might also try rebuilding the offending form or using the undocumented
SaveAsText feature to copy the form properties, then reimport them. The
relevant code would be something like (aircode):

Sub foo ()
Application.SaveAsText acForm, "FormName", "C:\FolderName\FormName.txt"
End Sub

then to reimport (after renaming or deleting the original)

Sub foo2 ()
Application.LoadFromText acForm, "FormName", "C:\FolderName\FormName.txt"
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access