"Property Value is Too Large"?????

[Zoe]

I am creating a new table for 225 fields. I have ~140
entered, but when I try to enter any more fields a
warning pops up and says that the "property value is too
large." I have no idea what this means or how to remedy
it. Please help!!!

 

[Duane Hookom]

This suggests you have too many fields and too many characters stored in a
single record. 225 fields is generally about 200 too many.

 

[Van T. Dinh]

There is another restriction besides the limit of 255 Fields in the Table:
the max size of the Record is 2K bytes for A97 (I think for A2K0 and later,
the max is 4K but then the Unicode needs 2 bytes per character
uncompressed). Memo Fields and BLOB Fields are not included in the limit
(except for a number of bytes , possibly 16, being used as "pointer"???).

Once the Record hits the max. size, you get this error.

As Duane wrote, you probably need to denormalize your Table as in properly
normalized databases, Tables tend to be long (lots of Records) but narrow
(small number of Fields).

 

[Tim Ferguson]

As Duane wrote, you probably need to denormalize your Table as in
properly normalized databases,

ITYM "normalize your Table" ...

Tim F

 

[Van T. Dinh]

Thanks, Tim.

Forgot to proof-read ...