Microsoft KB Archive/323657

= ACC2000: Error Saving Table Error Message After Design Change =

Article ID: 323657

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q323657



Novice: Requires knowledge of the user interface on single-user computers.

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



SYMPTOMS
When you try to save a table after you make a design change, you may receive the following message:

Property Value Is Too Large

This error can occur when you save a table after you make any of the following changes:
 * Add a new field
 * Add a Lookup to a field
 * Add a Description to a field



CAUSE
This issue can occur for either of the following reasons:
 * A large number of fields (over 150) are in the table and the field names are long (over 15 characters).
 * The Default Value property has been set for several Memo fields in a very large table.



RESOLUTION
There are several ways to resolve this issue:

NOTE: Before you try any of the methods listed below, compact your database.

Method 1
Reduce the number of fields in the table. A large number of fields indicates that the database design may be inefficient.

For additional information about database normalization, click the article number below to view the article in the Microsoft Knowledge Base:

209534 ACC2000: Database Normalization Basics

For additional information about designing a questionnaire database, click the article number below to view the article in the Microsoft Knowledge Base:

209493 ACC2000: Sample Table Design to Support Questionnaire Applications

Method 2
Split the table into multiple tables and use a one-to-one relationship among the tables.

For additional information about creating relationships in a Microsoft Access database, click the article number below to view the article in the Microsoft Knowledge Base:

304467 ACC2000: Defining Relationships Between Tables in a Microsoft Access Database

Method 3
Reduce the length of the field names.

Method 4
Remove the Default Value for any Memo fields in the table.

Additional query words: prb acc2000

Keywords: kbprb KB323657

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.