Posted on 2004-10-29
We are migrating our Access application from desktop to Terminal Server while also moving from Windows 95 to Windows 2000 clients. Our backend is Oracle 8173. We have changed our character setting on Oracle for some reasons.
Sometimes users copy text from MS Word and paste it in Access Text fields. This text can also contain apostrophes('). This used to work fine in Windows 95 version. But now, such apostrophes throw special characters, instead of normal '. Any idea why this is happening? Is it something to do with the character setting on Oracle or is it Access issue?
Your suggestions are highly appreciated.