Access 2000 character..

[Guest]

... record limitation.
Where in Help can I find information about this limitation?

Does it mean that across all columns there cannot be more than 2000
characters held?

I read it at:

I am getting the Record Is Too Large error..
I will check to be sure there are not text fields SET TO TO LOW TEXT CHARS...

 

[Guest]

Is it true that this 2000 character limit does not include the characters
that occupy a Memo text field??

 

[Allen Browne]

That is correct.

The limit applies both to a table, and also to a query that may be
outputting fields from multiple tables.

If some of your fields are wide text fields, you could convert them into
memo fields. Regardless of how much text is in the memo field, is only
contributes around 10 bytes to the width (just field header info such as the
address to the data.) I suggest you do this only with fields that are not
used for selecting, sorting, or de-duplicating in your queries.

 

[Douglas J Steele]

In addition to what Allen's told you, the size of the text field doesn't
matter: it's how much text is in the field that does.

You can create a table that has 20 text fields, each capable of holding 255
characters and Access will cheerfully work with that table. However, as soon
as the contents of the text fields in total exceed 2000 characters, you'll
get the error.