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

 

[Allen Browne]

The maximum number of characters you can have in all the fields of a record
is around 4000 characters, or 2000 in some versions and languages (unicode.)
So, if you have 20 text fields, each with 255 characters in them, you have
exceeded this limit.

If you really are storing large volumes of text in the record, you could
solve the problem by using Memo fields instead of Text fields. Each memo
counts as only an address (10 bytes or so), regardless of how much text is
actually in the field.

A more common problem is that new users sometimes try to put too many fields
in the one table instead of using a relational design. Typically there are
many repeating fields (Week1, Week2, ... or Employee1, Employee2, ...) that
should actually be many *records* in a related table.

If that applies, here is a list of resources to read more about how to
design relational databases:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

 

[Konchetta via AccessMonster.com]

Thank you so much Mr. Browne. I always look forward to hearing your solution
to a problem. You are very appreciated and I will try to change some of the
fields to Memo fields!!!
Konchetta

The maximum number of characters you can have in all the fields of a record
is around 4000 characters, or 2000 in some versions and languages (unicode.)
So, if you have 20 text fields, each with 255 characters in them, you have
exceeded this limit.

If you really are storing large volumes of text in the record, you could
solve the problem by using Memo fields instead of Text fields. Each memo
counts as only an address (10 bytes or so), regardless of how much text is
actually in the field.

A more common problem is that new users sometimes try to put too many fields
in the one table instead of using a relational design. Typically there are
many repeating fields (Week1, Week2, ... or Employee1, Employee2, ...) that
should actually be many *records* in a related table.

If that applies, here is a list of resources to read more about how to
design relational databases:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

Good Morning,

[quoted text clipped - 19 lines]

Thanks for any assistance provided.
Konchetta

 

[Konchetta via AccessMonster.com]

Mr. Browne,
I hope that you can retrieve this message. I changed 18 fields to MEMO
datatypes in my table but when I try to resave the table it now says Record
is Too Large as well. The first time the error stated something about the
indexing would change and duplicate data was already in the field. I did
design a new table that have the 18 fields as MEMO which saved but now I have
a problem getting ALL my data to that table without errors. I think I just
need to try and learn the Relationship part of the query to combine two
tables. I tried to do that but when I run the query it only picks up data
from one table. I am at a lost for now but still trying.
Thanks for your help.
Konchetta

Thank you so much Mr. Browne. I always look forward to hearing your solution
to a problem. You are very appreciated and I will try to change some of the
fields to Memo fields!!!
Konchetta

The maximum number of characters you can have in all the fields of a record
is around 4000 characters, or 2000 in some versions and languages (unicode.)

[quoted text clipped - 20 lines]

 

[Allen Browne]

Create a new table with the memo fields.

Use an Update query to populate it from the old table.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mr. Browne,
I hope that you can retrieve this message. I changed 18 fields to MEMO
datatypes in my table but when I try to resave the table it now says
Record
is Too Large as well. The first time the error stated something about the
indexing would change and duplicate data was already in the field. I did
design a new table that have the 18 fields as MEMO which saved but now I
have
a problem getting ALL my data to that table without errors. I think I just
need to try and learn the Relationship part of the query to combine two
tables. I tried to do that but when I run the query it only picks up data
from one table. I am at a lost for now but still trying.
Thanks for your help.
Konchetta

Thank you so much Mr. Browne. I always look forward to hearing your
solution
to a problem. You are very appreciated and I will try to change some of
the
fields to Memo fields!!!
Konchetta

The maximum number of characters you can have in all the fields of a
record
is around 4000 characters, or 2000 in some versions and languages
(unicode.)

[quoted text clipped - 20 lines]

Thanks for any assistance provided.
Konchetta

 

[John Vinson]

Create a new table with the memo fields.

Use an Update query to populate it from the old table.

An Append query, rather than an Update query, right Allen?

John W. Vinson[MVP]

 

[Konchetta via AccessMonster.com]

Thanks Mr. Browne and Mr. Vinson. Will try these...

 

[Allen Browne]

Yes, John. Thanks.