Number of characters in a record 2000?

[Vladislav Moltchanov]

In Access 2000 help
one can find the topic

Microsoft Access database table specifications
which contains the line:

Number of characters in a record (excluding Memo and OLE Object
fields) 2,000

What could it mean. I have created a table with 10 text fields each of
length 255 and each filled with 255 length text. This table was
processed routinely, no error or warning has come

Could anybody explain, what exactly does it mean, "Number of characters
in a record ".

[Salad]

Vladislav Moltchanov wrote:

In Access 2000 help
one can find the topic

Microsoft Access database table specifications
which contains the line:

Number of characters in a record (excluding Memo and OLE Object
fields) 2,000

What could it mean. I have created a table with 10 text fields each of
length 255 and each filled with 255 length text. This table was
processed routinely, no error or warning has come

Could anybody explain, what exactly does it mean, "Number of characters
in a record ".

I created a table with Text1--Text10. I went to Text1 and entered the
number 1 255 times. I then copied the data from Text1 into the other
fields. Sooner or later I received the message "Record is too large.".
Help stated that although when you design the table that exceeds 2000
characters,the error will occur when data is entered.

THen again, I'm using A97. Maybe A2K's specifications were not updated
in help if you can exceed the limit.