[AccessD] Property Value is too large

[John Colby]

Well you've piqued my curiosity.  What is the table?

BTW I ran into the same kinds of issues with SQL Server as well.  I was
asked to deal with a database with a table that had more than 720 fields on
it and wanted to index many of them.  Same kind of thing, max number of
indexes in this case.

On Sun, May 14, 2023 at 6:27 PM 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
>


-- 
John W. Colby
Colby Consulting