[AccessD] Property Value is too large

[Arthur Fuller]

I remember that table,John. The approach I came up with was to store the
columns as bits, in groups.

On Mon., May 15, 2023, 1:05 p.m. John Colby, <jwcolby at gmail.com> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>