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

Maximum record length

P: n/a

Does anybody know the maximum length of a record in MS-Access? I keep
getting "record is too long" messages.

Until now I found out (I think) that this message has nothing to do with
the number of fields and the fieldlengths defined, but rather with the
actual amount of data put into them. Is this correct?
--
Posted via http://dbforums.com
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
A2000 Help:

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

Peter Russell

jasperdejonge previously wrote:

Does anybody know the maximum length of a record in MS-Access? I keep
getting "record is too long" messages.

Until now I found out (I think) that this message has nothing to do with
the number of fields and the fieldlengths defined, but rather with the
actual amount of data put into them. Is this correct?
--
Posted via http://dbforums.com


Nov 12 '05 #2

P: n/a
TC

"jasperdejonge" <me*********@dbforums.com> wrote in message
news:34****************@dbforums.com...
Does anybody know the maximum length of a record in MS-Access? I keep
getting "record is too long" messages.
It's in online help (as the other respondend said).

Until now I found out (I think) that this message has nothing to do with
the number of fields and the fieldlengths defined, but rather with the
actual amount of data put into them. Is this correct?


Yes. In general, each variable-length field (like a tyext field) takes a
byte or so from the data record, plus the number of bytes that is actually
stored in the field. So the data that is *actually stored*, has the biggest
impact on the record length.

HTH,
TC

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.