View Single Post
  #3  
Old July 28th, 2004, 04:56 PM
Van T. Dinh
external usenet poster
 
Posts: n/a
Default "Property Value is Too Large"?????

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

--
HTH
Van T. Dinh
MVP (Access)


"Zoe" wrote in message
...
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!!!