[AccessD] Property Value is too large

[Arthur Fuller]

I am having the same problem with that table. Would you be so kind as to
send me a copy of the fixed table?

On Sun., May 14, 2023, 6:27 p.m. Stuart McLachlan, <stuart at lexacorp.com.pg>
wrote:

> First time I've run across this in 30 years. I've been developing
> contantly in  Access since
> 1993 and never seen it before.
>
> When trying to add another field to a table, I got the message "Property
> Value is too Large"
> and couldn''t save the change. In fact I couldn't even save the table if I
> deleted a field in it - I
> got the same error
>
> This particular , table (which I did not design - but a couple of people
> here might recognise)
> had 178 fields!   Many of the fields had "Lookup" Comboxes specified
> containing long SQL
> select statements. Also a load of long "Descriptions".
>
> It turns out that there is a limit to the size of a table definition that
> Acceess can store (2KB ? )
> and  this is not just for the table structure , it  includes the Lookup
> and Description data for
> each field and the Index definitions. ( there are 20 indexes specified for
> this table, even just
> trying to delete one and saving the table gave the same message).
>
> After I cleaned a lot of the garbage out (primarily Lookup comboxes),  I
> was able to add the
> field.
>
> Yet another reason why I dislike specifying anything other than the
> default for field display in
> the table design - IMNSHO, that's NOT where user interfaces should be
> specified!!!
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>