"Property Value too large"

[Wayne Viles]

After entering a lot of fields in a Table, when trying to save, I get the
message "property value too large". What does this mean?

 

[Tom Wickerath]

Hi Wayne,

Please see this KB article:
Error Saving Table Error Message After Design Change
http://support.microsoft.com/?id=323657

Note that the title includes "ACC2000", but it applies to later versions of
Access as well. Anytime you have such a large number of fields in a table, it
is nearly always guaranteed that you do not have a normalized design. Here
are some links to database design articles that will help you work through
this issue:

http://www.datatexcg.com/Downloads/DatabaseDesignTips1997.pdf

http://www.datadynamicsnw.com/accesssig/downloads.htm
(See the last download titled "Understanding Normalization")

http://support.microsoft.com/?id=234208
http://support.microsoft.com/?id=289533

Don't underestimate the importance of gaining a good understanding of
database design. Brew a good pot of tea or coffee and enjoy reading!


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________