Forum Stats

  • 3,783,408 Users
  • 2,254,768 Discussions


MS Access and Oracle Database

housetiger77 Member Posts: 30 Blue Ribbon
edited Dec 5, 2018 8:24AM in ODBC

I've created a MS Access 2016 front end application and i'm using Oracle 11g as the back end database. I'm using the 11.2 ODBC driver to link them and I'm having an issue with Access not displaying certain symbols. The symbol in question is the diameter symbol and to display it you have to type ALT + 0216. The Oracle table shows the symbol correctly, but when viewing it in Access it does not. There seems to be a disconnect in how Access translates the data from the Oracle db. I've tried changing some of the settings on the ODBC driver, but nothing has helped. The data_type for the column is VARCHAR2 (4000) and in Access that is equivalent to Long Text. Does anyone have any clue what the issue might be? Any help is appreciated!