Spell Check not available in Access 2003 runtime

[johnb]

Hi,

We are using Access 2003 runtime to run an ade which has the
RunCommand(acCmdSpelling) coded in it for spell checking.

On a full version of Access 2003, spell check works fine and highlights
any errors, but on the runtime version of 2003 the spell check always
mysteriously says the spell check is OK even when there is an obvious
spelling mistake.

I have seen posts in this group regarding a mis-match between Access
and Word (e.g. Access 2000 and Word 97) causing a problem, but here the
user has the same versions of Access and Word.

I have also checked the spelling mistake in Word on the user's machine
and Word detects the mistake correctly.

Any help greatly appreciated.

JB

 

[Ron Weiner]

I am pretty darn sure that all of the access runtime environments do NOT
support spell checking. I am also fairly certain that the Access Spell
checking modules are NOT redistributable.

I have a widely distributed application that occasionally has to be
installed with the Access runtime (we use the 2002 runtime). In order to
keep my runtime clients from becoming second class citizens, if the client
has any version of office 97 or better, we automate Office (using late
binding) and leverage the spell checker in Word. It is a little on the
kludgy side, and slow (especially the first time a spell check is run in the
session), but it does allow for checking and correcting spelling errors. As
we keep the Word window off the screen, most users never realize that Word
is doing the spell check for them.

 

[JB]

Hi Ron,

Thanks for your reply. Your first paragraph makes sense, as that is
what appears to be happening in our environment.

I'll try the Word work around, not nice but the only option without
involving third party spell checkers I guess.

Thanks

JB

 

[Rick Brandt]

Hi Ron,

Thanks for your reply. Your first paragraph makes sense, as that is
what appears to be happening in our environment.

I'll try the Word work around, not nice but the only option without
involving third party spell checkers I guess.

Spell checking does work in the runtime if you install it on a PC that has the
same version of Office. In other words, if the user has Office 2003, but not an
edition that includes Access then your 2003 runtime would be able to
automatically utilize the spell checker from his Office version. If the version
of Office was older then the other poster's suggestion would be the way to go.

 

[JB]

Hi Rick,

I've had a bit more of a think about this now and what you said makes
sense because all the spell check was working fine when the user was
using Access 2000 and Office 2000. We recently upgraded to 2003 for
both Access and Office and now the spell check fails?

The strange this is, it doesn't fail, it completes with the message
saying Spell Check is complete, yet it has missed quite obvious
spelling errors. I tried spell checking the same spelling errors in
Word on the users machine and Word errored them correctly. So the issue
appears to be with spell check not detecting errors rather than not
being available.

JB