By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,807 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,807 IT Pros & Developers. It's quick & easy.

Number of characters in a record 2000?

P: n/a
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 ".
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.