Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    7

    Question Unanswered: Trouble with a 'text' data type using an Access Project (ADP) connected to SQL Server

    I am using a 'text' data type in a table and am having trouble adding data to it. I'm using an MS Access ADP project front end for my forms and I am connecting to SQL Server as user 'sa'. I want to copy and paste from a text editor such as NotePad to a 'text' data type field in a form. There appears to be a limit that the field will accept which is much below the 2GB size that is allowed for the field. I get the following error message: "The text is too long to be edited." Once I get this error I can add characters from the keyboard but eventually the field will not accept any more characters. Typing or pasting does nothing. I can delete. So I've hit a limit but I'm not sure if it is in Access or SQL Server.

    Any help would be appreciated.

    Dennis Geasan

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Use nvarchar?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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