Access 2000/Oracle ODBC Error

[richardii]

I have set up an ODBC link to an Oracle database.

I receive the message:

"The width of a UNICODE text column must be an even number of bytes"

when querying data from a table. Ive tried setting the Force Retrieval of Long columns flag in ODBC (for the Oracle driver). The registry entry looks okay (as far as I can tell). Still does it though....

Any tip appreciated.

This is a known problem, I followed their advice (it's known by University of Arkansas) -

http://www.uaex.edu/bknox/ms_access_2000_oracle_long_datatype.htm