Professional Web Applications Themes

Access 2000 Data Viewing Issue - Coldfusion Database Access

I am running an application on ColdFusion MX7 server against an Access 2000 DB. There is a specific field within one of the tables that is setup as a memo data type to handle large amounts of data. I am having an issue displaying all the data from the specific field. I cannot edit the field via the user interface because it tells me its too large, but I have been able to cut and paste it into a word doent. I see that there is more text there than what is being returned and displayed via the web page. ...

  1. #1

    Default Access 2000 Data Viewing Issue

    I am running an application on ColdFusion MX7 server against an Access 2000 DB.
    There is a specific field within one of the tables that is setup as a memo
    data type to handle large amounts of data. I am having an issue displaying all
    the data from the specific field. I cannot edit the field via the user
    interface because it tells me its too large, but I have been able to cut and
    paste it into a word doent. I see that there is more text there than what
    is being returned and displayed via the web page. Is this a driver limitation?
    What else can I do?

    bfinelsen Guest

  2. #2

    Default Re: Access 2000 Data Viewing Issue

    In the cf admin, go to the datasources and click on your datasource name.
    Then at the bottom look for the CLOB settings.

    You may need to enable them

    Ken
    The ScareCrow Guest

  3. #3

    Default Re: Access 2000 Data Viewing Issue

    Thank you so much, I never even looked at the advanced settings to see that option.
    bfinelsen Guest

Similar Threads

  1. mx2004/MySQL/PHP Issue with viewing data
    By LuCyrne in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: February 27th, 06:26 PM
  2. How to pass data from Ms Access 2000 to a pdf file field Using only acrobat reader
    By Paolo_Delos_Santos@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 3
    Last Post: May 1st, 01:38 AM
  3. Access 2000 or SQL Server 2000
    By Denis in forum ASP Database
    Replies: 1
    Last Post: January 25th, 03:38 PM
  4. Embedded font issue - how common are NT/2000/XP machines without Admin access
    By David Downie in forum Macromedia Director Basics
    Replies: 3
    Last Post: August 9th, 10:28 PM
  5. access 97 to 2000 conversion issue - combo box blank
    By Tom R in forum Microsoft Access
    Replies: 5
    Last Post: August 4th, 04:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139