Not wanting to seem too ignorant of the problem here, but this is only a problem with vba constructed sql, no? I know you can search, delete and append (so I guess update too) data with forms tied to queries or tables with no problem when it's "joey's" instead of "joeys". Not saying things like apostrophes or commas are good things to have in data, and I guess it might be queries and forms today but vba sql tomorow - just wondering if there really isn't an issue at present. I guess I've always had the luxury of clean data...
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.