Hello everyone,

I am using Oracle ODBC to connect tables from an Oracle schema to an empty
Microsoft Access DB.

In one particular table i have a VARCHAR2 field that is 255 chars long.

This field is reported as being of MEMO type in Access, which is untrue.

Problem is that another third-party (that reads the Oracle data sw) has
problems using Memo fields.

Can anyone help me in forcing ODBC driver to report the field as TEXT in
Access, as it should be?

TIA
Paolo

Strange Cat @ Work schreef:
Could it be that your NLS_LANG setting is referring to a multi-byte characterset? Text is max
255 characters, maybe the ODBC driver thinks you may need more.

Thanx for answering...

I'll check with the DBA.

Problem is that I dont think they are willing to change their NLS_LANG
setting.

I wonder if there is a way to force ODBC driver to believe there is no
multi-byte charset in Oracle instance, of course without messing up the data
retrieved...

TIA
Paolo