"JohnH" <Jo**********@gmail.comwrote in message
news:11*********************@p15g2000hsd.googlegro ups.com...
I'm very interested in implementing double-metaphone search in my
database to resolve customer names, and I've done quite a bit of
searching trying to find a VBA implementation. I know that Clive
Bolton spent quite a bit of time creating one several years ago (an
A97 demo mdb), but it doesn't seem to be publicly available. I would
greatly appreciate it if someone who has one might share it. Failing
that, I would also appreciate code for Soundex 2, which I also can't
seem to find. Thank you in advance.
I'm not a specialist in this area, but a Google Search with "Microsoft
Access" (quote marks included) in the text box entitled 'with all these
words' and "Soundex" (quote marks not included) in the text box entitled
'with the exact phrase' gave approximately 12,700 matches. A Soundex
implementation for Visual Basic could also be applicable. I only found a few
matches for "Soundex" in the Microsoft Knowlege Base at
http://support.microsoft.com, and those were for Transact-SQL (Microsoft SQL
Server and Access ADP) -- but, perhaps you could adapt them to Access'
flavor of SQL.
I do recall that there was an Access Knowledge Base article on Soundex, in
the past, but I did not find it on a current search.
Larry Linson
Microsoft Access MVP