ntext getting truncated

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi I have an access application with linked table to sql server. One of the
linked table in access is memo field while the corresponding sql server field
is ntext. From the front end of the application one can add rather big
description of problem in the memo field. However in the corresponding sql
server field(ntext) part of the problem descriptioin is getting truncated. I
am not sure why. The form fields are directly linked to the linked sql server
table.

I appreciate any help for resolution of this issue.
Thanks.
.

Relevant Pages

  • Re: ntext getting truncated
    ... If you are seeing the truncated results in SQL Server Management Studio, or in Query Analyzer, you may be suffering from the limits of those tools. ... description of problem in the memo field. ... server fieldpart of the problem descriptioin is getting truncated. ...
    (microsoft.public.sqlserver.programming)
  • Re: Text too long to be edited
    ... I don't know much about Access but I suspect you are trying to edit data via an Access form or grid. ... Since the problem occurs when you attempt edit some existing rows but not others and occurs with both Access and SQL Server databases, it looks to me like there is some built-in Access data length restriction. ... When I click in certain records in a memo field, I get the error message "text too long to be edited", and I can't get into the record to make any changes. ... I tried exporting the record to html, but only part of the memo field is exported. ...
    (comp.databases.ms-sqlserver)
  • Re: ntext getting truncated
    ... Out of curiosity, have you considered moving from ntext (older, deprecated, ... problematic) to nvarchar(newer, shinier, less problematic)? ... Also do you know if the data stored in the SQL Server column is truncated ... description of problem in the memo field. ...
    (microsoft.public.sqlserver.programming)
  • Re: Splitting memo field entry into rows
    ... MS SQL Server has a field type TEXT which can store up to 2 gigs of data. ... I thing you are wise to split out the data into a new table as ... separate column. ... > I'm trying to export a table from Access to SQL Server with a memo field ...
    (microsoft.public.access.modulesdaovba)
  • Re: re : Accessing BLOB fields through ADO in VBS
    ... I used Paradox to cast the MEMO field as a string, then updated the SQL Server using an UPDATE statement and pass-through SQL. ... paradox database containing memo or blob field in to sql server. ...
    (comp.databases.paradox)