Using OLEActivate Error message

[Eightball3]

I'm using Access 2000 in Windows 2000. I have some VBA code that is supposed to play a sound. Here it is. Me![found].action = acOLEActivate. [Found] is an OLE Class Microsoft Sound Recorder Server. I used the command above to activate and play the sound. It worked great on WinNT with Access 97 but not in Win2K Access 2000. I get the following error message. 'A problem occurred while Access was communicating with the OLE server or ActiveX Control.'

Do I need to set a reference in the library..if so which one? Thanks for any suggestions. Maybe there is a better way to play this sound?

 

[Eightball3]

Anyone?

 

[rainsworth]

I'm Having the same problem. Did you resolve this issue?

 

[danvlas]

I got the same message for various ActiveX objects when my form was initially created by a wizard (laziness, oh sweet laziness).
When I re-created the form from scratch, the problem was gone.

Don't ask me why, and I can't say it will surely work for you. But it's worth a try.

Good luck



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[ReluctantDataGuy]

I had this error. I closed and restarted the database and it didn't happen again. I thought it was because I was playing with the code and the OLE server got confused. Haven't had the error since then...