Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / ActiveX Controls / December 2003

Tip: Looking for answers? Try searching our database.

OLE Server Stops Communicating

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter - 18 Dec 2003 04:12 GMT
I'd like to consolidate information from a number of
previous posts in the hope that someone can point me at
documentation so that I can avoid or automatically mend
this misbehaviour.

I have an Access 97 application that needs to record and
playback sounds stored in a table.
The record button includes code that used to work fine
repeatedly:
    Me!Speech.Locked = False
      Me.Speech.Enabled = True
       Me!Speech.Class = "soundrec"
       Me!Speech.ACTION = acOLECreateEmbed
       Me!Speech.Verb = acOLEVerbPrimary
       Me!Speech.ACTION = acOLEActivate
Clicking on the bound object field on my form would play
back the recorded speech fine too.
The application was moved back and forth between an XP
platform at home and both an XP and 2000PE platform at
work.  Note that it will eventually be hosted in an NT
4.0 environment. The moving platforms seemed to break the
OLE Server Connection so that while sounds would still
play back fine, an attempt to re-record using the above
button would crash at the ACTION = acOLECreateEmbed  
instruction with the alert:
"A problem occurred while Microsoft Access was
communicating with the OLE Server.
Close the OLE Server and restart it outside of MS Access."

I found a knowledge-based article that suggested Norton
Antivirus could be the problem so I removed that program
but to no avail.  Trying to bypass the instruction if the
properties were already set bypassed the record function.

Problem solved temporally thus: Created a new form and
table. I Copied data from the old table storing sounds to
the new one piece-by-piece. I then copied code behind
controls and for events from the old form to the new
one.  I reconnected rest of the application to the new
form and table. It magically worked again - until
transported to another platform that is, when the
phenomenon recurred.

Surely there is a technique whereby whatever is hanging
up the OLE Server can be avoided or at least
automatically mended?  One might be able to exogenously
intervene by right clicking on the sound field in the
underlaying table to edit/re-record sounds but that is
not very elegant nor user friendly. I would appreciate a
pointer to some documentation or a tip as to what is
happening and how it should be managed.
jag - 18 Dec 2003 22:39 GMT
lala
> I'd like to consolidate information from a number of
> previous posts in the hope that someone can point me at
[quoted text clipped - 47 lines]
> pointer to some documentation or a tip as to what is
> happening and how it should be managed.
jag - 18 Dec 2003 22:40 GMT
lala
> I'd like to consolidate information from a number of
> previous posts in the hope that someone can point me at
[quoted text clipped - 47 lines]
> pointer to some documentation or a tip as to what is
> happening and how it should be managed.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.