File Format & Compatibility

Fix Oracle Apostrophes Displayed as Question Marks in Microsoft Access

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 868 views

Question details

Determine why apostrophes from Oracle data appear as question marks in Microsoft Access on some computers.

Fix Oracle Apostrophes Displayed as Question Marks in Microsoft Access
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.
Before you start

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.

Solution 1Recommended

Compare Oracle ODBC and Windows settings

Use this approach when the same Oracle value displays correctly on one computer but not another.

1
Check the source value

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.

2
Compare ODBC data sources

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.

3
Review driver character support

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.

4
Compare regional settings

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.

Compare Oracle ODBC and Windows settings
System locale changes affect other applications: Changing the Windows system locale can affect other non-Unicode programs and may require a restart. It is not guaranteed to fix Unicode data conversion.
Free Microsoft Office alternative

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.

Review exported Oracle data in a spreadsheetOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for a smoother transition from Microsoft OfficeWork with a free, lightweight office suite
QA img-9

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.