Property value to large??

[chubby]

I needed to expand my table some more. I have less than 170 fields in this table, but very time I tried to save it comes up property valve to large. What does that mean?

 

[VBslammer]

Access can handle up to 255 fields in a table, however that many fields usually indicates a poorly designed schema. Here is the Microsoft explanation:

ACC2000: Error Saving Table Error Message After Design Change
The information in this article applies to:
Microsoft Access 2000

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:
Q209534 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:
Q209493 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:
Q304467 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.
VBSlammer