Short version: I have a view in Oracle. I have created a link in MS Access 2007 to this view. It works fine except for the fact that one value from the view get data type PM instead of TEXT. This leads to Error 3118 in MS Access when I try to link to tabels into one question using this value.
In the view the field that gets data type PM in MS Access has data type Varchar2(4000)
In the attached document there is a detailed description.