Solved

Text to Speech Using SAPI in Access

Posted on 2014-01-02
9
1,040 Views
Last Modified: 2014-01-13
Hi,

I had a small spoken welcome message in my access application using SAPI text to speech. It was all working fine until I upgraded to Windows 8.1.

I have included the reference in tool to the "Windows Speech object" but still get the error 429 Activex can't create the object.

What do I need to do to get this working again?
0
Comment
Question by:ynot8669
  • 6
  • 2
9 Comments
 

Author Comment

by:ynot8669
ID: 39752903
Forgot to mention I am using Access 2010
0
 
LVL 21
ID: 39752952
I don't think it is an Access issue but an issue with  installing SAPI.

From: How to redistribute SAPI 5.1 core components
Applications that are developed based on Speech Application Programming Interface (SAPI) version 5.1 require that you install the SAPI 5.1 core component on the client computer.


Have you insured that SAPI is installed?
0
 

Author Comment

by:ynot8669
ID: 39752978
I have not installed any SAPI SDK. Windows 7 and 8 just worked with a very simple VBA script. It has just stopped working after the Win 8.1 upgrade.

I do not really want to install extra software on all of the user PC's.

I have included the reference to C:\windows\system32\Speech\Common\sapi.dll
and physically checked that the dll is present ...it is
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 42

Expert Comment

by:pcelba
ID: 39753265
Microsoft delivers various backward incompatible SAPI versions without any warning...
So the programs working with SAPI 4 can stop working on computers having SAPI 5 etc.

To ensure the functionality you really have to install the SAPI version which is compatible with your program or install the appropriate SAPI version on the target computer.

A workaround is to play some WAW sound instead of TTS synthesis.
0
 
LVL 21
ID: 39754650
ynot8669,

To verify it is not a version issue:

Open the folder: C:\windows\system32\Speech\Common\

Right click on the sapi.dll file  and select properties. Click the Details tab. There you will find the File Version. Compare the Windows 8.1 version and your version. If they are not the same version then that is probably the issue.

Have you tyied converting your code to Late Binding?
0
 

Author Comment

by:ynot8669
ID: 39755472
My Win 8 PC is using 5.3.15125 and
Win 8.1 is using 5.3.16513

After some debugging I found that the error is related to something Audio. The voice was used behind a Logon Screen and the error was also causing the modal popup to disappear.
This might be something to do with using two screens but again this worked prior to the upgrade.

I found this code to test for SAPI Presence and added the error:
Private Sub Form_Load()
Dim RC, myGrammar, gSAPIPresent
   On Error GoTo SAPINotFound

    Set RC = New SpSharedRecoContext

    Set myGrammar = RC.CreateGrammar
    myGrammar.DictationSetState SGDSActive
    gSAPIPresent = True
    Exit Sub

SAPINotFound:
    If Err.Number = 459 Then
        MsgBox "SAPI not found"
    ElseIf Err.Number = -2147200904 Then  'SPERR_AUDIO_NOT_FOUND    whatever that might be
        Else
        MsgBox "Error encountered : " & Err.Number
    End If

    gSAPIPresent = False
End Sub

My issue is with the SPERR_AUDIO, I have maximized the logon form ...looks silly but with the above code and a screen maximise the speech works fine.

I will move to another 8.1 machine and see if it's my set-up or common accross machines.
0
 

Author Comment

by:ynot8669
ID: 39755803
It seems to be an issue on my main set-up or subtle difference between Office 2013 and 2010. The issue setup in Office 2010 and my other PC is Office 2013 which reconfigured itself on first launch and worked unaltered and as expected.
0
 

Accepted Solution

by:
ynot8669 earned 0 total points
ID: 39767185
The problem has been self solved. I removed the On Load event and changed the form auto centering property to NO. It seems that using two screen centered the modal/popup in between both screens ...that is not visible on either.

Am unsure as to why this only occurred after the Win8.1 update, but for now I'll blame the upgrade.
0
 

Author Closing Comment

by:ynot8669
ID: 39776124
Self Solved and actual cause only presumed.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question