ACC97: SQL Memo Fields Truncated to 255 in Update Query

MORE INFORMATION

Steps to Reproduce Problem

1. Create a table called TEST in MS SQL Server 6.5 with the following structure:
   

         Key   ColumnName   Datatype  Size  Nulls  Default
         ----  -----------  --------  ----  -----  -------
          Y    EmployeeID   int       4
               LastName     char      25
               Notes        text      16      Y
               Notes2       text      16      Y
   						

2. Open the sample database Northwind.mdb.
3. Create a link to the Test table you created in step 1.
4. Create an append query that appends the EmployeeID and Notes field from the Employees table to the EmployeeID and Notes field in the Test table. This will provide sample data for the SQL table.
5. Create an update query based on the dbo_test table in Microsoft Access by typing the following syntax in the SQL View window:
   

         UPDATE dbo_Test SET dbo_Test.Notes2 = [dbo_test]![notes]
         WHERE (((dbo_Test.EmployeeID)=2));
   						

6. Run the query.
7. Open the dbo_Test table to view the results.
   
   Note that the query updates the Notes2 Memo field with the data from the Notes Memo field. However, the data in the Notes2 field is truncated at 255 characters.