Property Value Too Large
Question:
I'd like to create a table with 240 fields. I know that the max is 255, however, I'm getting a message "property value too large" after I've created 114. Any ideas? All the number fields are byte size. Thanks!
Answer:
You might do a Compact and Repair and gain the ability to add more fields. It has been my experience that when people need that many fields, there is a normalization problem. With a relational database like Access you should be thinking tall and slim tables (lots of records and not many fields in each record)...
Krijoni Kontakt