how to configure Access to Link to a UTF-8 database?

[WPenfold]

Hi, How can I configure Access to link to a UTF-8 database and see the data?
I can link to tables OK, and display the data as long as there are no multi
byte characters. Any row containing any data with multi byte UTF-8
characters however, shows '#deleted' as the value of every column.

 

[Chris O'C via AccessMonster.com]

What utf-8 dbs are you trying to link to? Access comes with standard drivers
to link to other db types. Some allow unicode, some don't. You might be
able to convert to another db file type and link Access to those converted
tables. Or maybe link to the utf-8 db from SQL Server as a linked server,
and then link from Access to SQL Server. I think you'd see unicode chars in
the linked table when viewed from Access but I don't know for sure.

Chris

 

[WPenfold]

I'm connecting to an Oracle database using an Oracle ODBC driver. I can
connect and see the UTF-8 data in MS Access fine...as long as it doesn't
contain any multibyte characters. As soon as it hits a row with multibyte
characters like à then I can't see the data. I think the reason I'm getting
#Deleted is because the column with the multibyte characters is part of the
key. I made another table that just has some examples of multibyte
characters, but they just show up blank in Access.