Results 1 to 3 of 3
  1. #1
    leesider is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    4

    Fetched column value was truncated

    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?
    Attached Thumbnails Attached Thumbnails Cache.png  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    is this a field that has >255 characters?

  3. #3
    leesider is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    4
    Quote Originally Posted by ranman256 View Post
    is this a field that has >255 characters?
    It's a huge database with 17000 views and 14000 tables. What usually occurs when you have the connection made to the linked table (by clicking on OK on my screencap above) is that the list of objects is displayed in a list. I am not getting that list after I click OK (the logon credentials have been accepted). If you mean a field in a table where there is over 255 characters in the field title then no, I don't think there is.
    Would it be possible for me to do the import in a VBA function instead? Then I could loop through the code and just link the views I need (I only want to link six views from the db).

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA SQL query gets truncated
    By DCross in forum Queries
    Replies: 4
    Last Post: 06-19-2015, 03:44 PM
  2. Expand reports truncated field
    By Thompyt in forum Programming
    Replies: 1
    Last Post: 06-01-2015, 08:27 AM
  3. Truncated when exported to excel
    By memaxt in forum Import/Export Data
    Replies: 1
    Last Post: 09-05-2014, 12:58 AM
  4. Replies: 1
    Last Post: 02-22-2013, 09:39 PM
  5. Truncated field in my report
    By cvolkers in forum Reports
    Replies: 1
    Last Post: 03-08-2011, 12:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums