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.