ACC2002: Error Message: The Text Is Too Long to Be Edited

Article translations Article translations
Article ID: 321001 - View products that this article applies to.
This article was previously published under Q321001
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).


For a Microsoft Access 2000 version of this article, see 322874.

For a Microsoft Access 97 version of this article, see 322875.
Expand all | Collapse all

SYMPTOMS

If you try to type text in a memo field, you may receive the following error message:
The text is too long to be edited

CAUSE

This issue may occur when you try to type data in a field that has been upsized from the Memo data type in Microsoft Access to the SQL Server nText data type.

RESOLUTION

To resolve this issue, modify the data type from nText to Text or Varchar. To do so, follow these steps.

NOTE: To perform the procedure listed later in this article you must have appropriate permissions to modify database objects (db_ddladmin or db_owner).

  1. Start SQL Server Enterprise Manager, and then locate the server where the database is located.
  2. Expand the Databases folder, double-click the database name, and then click Tables.
  3. In the right pane of Enterprise Manager, right-click the table where the nText datatype field is located, and then click Design Table on the shortcut menu.
  4. Under Data Type, click the field that you want to modify, click the down arrow, and then click either Text or Varchar data type.
  5. Close the Design Table dialog box. Click Yes to save the changes that you made to the table design, and then quit SQL Server Enterprise Manager.
  6. Start Microsoft Access, and then open your database application.
  7. Click Tables, and then delete the linked table that contains the field that you modified in step 4.
  8. Re-link the table. To do this, follow these steps:
    1. On the File menu, point to Get External Data, and then click Link Tables.
    2. In the Files of Type box, click ODBC Databases().
    3. Click an existing DSN or click New to create a DSN that points to the SQL Server or MSDE that contains your table. Click OK.

      NOTE: The server may prompt you to log on. If you do not know the user ID and password, contact your system administrator.
    4. In the Link Tables dialog box, select the table that you want, and then click OK.

REFERENCES

For more information about SQL Server data types, see SQL Server Books Online available at the following Microsoft Web site:
http://technet.microsoft.com/en-us/sqlserver/bb331756.aspx

Properties

Article ID: 321001 - Last Review: November 14, 2007 - Revision: 3.3
APPLIES TO
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbprb KB321001

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com