Record is TOO Large Error

[Konchetta via AccessMonster.com]

Good Morning,

I am having the following error message since I have started entering data to
my FORM. All the fields in the Form are located in one Table. Could this be
the problem? Will I have to create new tables and create relationships with
the tables to still use the same FORM? Or will that still have an effect on
the individual RECORD data being too large?

Not much of a programmer so I tried to make my table design as simple as I
could because I'm not good with table relationships.

Record is too large. (Error 3047)
You defined or imported a table with records larger than 2K. This error
occurs when you enter data into the record — not when you define the table
structure. Redefine the table by making some fields shorter, removing
unneeded fields, or moving some fields to other tables.

Thanks for any assistance provided.
Konchetta

 

[NetworkTrade]

yep....any single record is limited to 2k size

Your table has too many fields and probably each field is at the default max
value.

Access will let you build it too large and won't give you the error until it
gets populated the first time.

You probably have a set of fields that can be split off into another table
by simply adding a common unique cross referencing field from the original
field. This new 2nd table then can be "re-merged" together with the first
via a query in terms of your forms or reports....

 

[Konchetta via AccessMonster.com]

Thanks Network Trade!!!

yep....any single record is limited to 2k size

Your table has too many fields and probably each field is at the default max
value.

Access will let you build it too large and won't give you the error until it
gets populated the first time.

You probably have a set of fields that can be split off into another table
by simply adding a common unique cross referencing field from the original
field. This new 2nd table then can be "re-merged" together with the first
via a query in terms of your forms or reports....

Good Morning,

[quoted text clipped - 15 lines]

Thanks for any assistance provided.
Konchetta