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.
"Chris O'C via AccessMonster.com" wrote:
> 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 wrote:
> >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.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ldata/200908/1
>
>
Similar Threads
