Fix Oracle Apostrophes Displayed as Question Marks in Microsoft Access
Question details
Determine why apostrophes from Oracle data appear as question marks in Microsoft Access on some computers.

- Product
- Microsoft Access and Oracle ODBC
- Device & OS
- Windows computers
- Scenario
- Users view Oracle data in Access on multiple computers and need apostrophes to display consistently.
- Observed behavior
- Apostrophes appear as question marks on some computers but display correctly on others.
Identify a record that displays differently on two computers and check the same value in an Oracle client. Note whether the affected character is a straight apostrophe or a typographic quote.
Compare Oracle ODBC and Windows settings
Use this approach when the same Oracle value displays correctly on one computer but not another.
Open the affected record in an Oracle client and compare it with the linked table in Access. If the Oracle value already contains a question mark, investigate the source data or data-entry process.
Open Windows ODBC Data Sources using the version that matches your Access installation, 32-bit or 64-bit. Select the Oracle DSN, choose Configure, and compare its driver version and settings with those on a working computer.
Check the Oracle ODBC driver's documentation and configuration for character-set and Unicode support. Align the driver and relevant settings with the working computer, then reopen the linked table in Access.
Open Windows Settings > Time & language > Language & region and compare the affected computer with a working one. If a non-Unicode application setting is relevant, review it under Control Panel > Region > Administrative > Change system locale; coordinate any change with your administrator.

Test the apostrophe character and font in Access
Use a small query to distinguish a font or character issue from a problem retrieving the Oracle value.
Standardize apostrophes in the source data
Use this approach if typographic quotes are causing compatibility problems and straight apostrophes are acceptable for the data.
Work with exported Oracle data in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Open exported data in WPS Spreadsheets and move between common Office file formats. It does not fix Microsoft Access or Oracle ODBC settings.

Frequently Asked Questions
Why does the same apostrophe display correctly on one computer but not another?
The computers may use different Oracle ODBC drivers, DSN settings, Windows regional settings, or fonts. Compare the same record and configuration on both computers to narrow down the difference.
How can I tell a straight apostrophe from a smart quote?
A straight apostrophe is U+0027. Typographic quotes include U+2018 and U+2019. In Access SQL View, run SELECT ChrW(39) AS StraightQuote, ChrW(8217) AS RightQuote; to compare two characters.
Will changing the font recover a question mark?
A font change may help if the original character is present but not displayed correctly. It cannot recover an apostrophe that was already converted to a literal question mark in the stored or retrieved data.
Which ODBC administrator should I open for Access?
Open the 32-bit or 64-bit ODBC Data Sources administrator that matches your Access installation, then select the Oracle DSN and choose Configure.




