I have an Access db I and I am trying to import tables from an Oracle 12c database (by linking them). I have successfully done this on a number of other machines but I am getting the error "ORA-01406 fetched column value was truncated" when I do it on a particular one. I have tried it with two different versions of Access (2007 and the 365 version). It works on other machines with 2007 and 365 but not this one.
The interesting thing is that if I increase the values in the screen capture attached to very large values and then enter the Data Source Name, Service Name, user id and password and connect, I don't get the error but the list of objects from the db does not appear either. Nothing happens and I have left it like that for over two hours.
Can anyone help with this?