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
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.