M
mcnewsxp
what is the max row size for access 2003?
tia,
mcnewsxp
tia,
mcnewsxp
K
Kevin3NF
max fields in a table is 255, each of which can be max 255 characters
(excluding memo and ole fields), so looks like 64K if they were all text.
If you get anywhere near 255 fields, you more than likely have a serious
design issue
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
(excluding memo and ole fields), so looks like 64K if they were all text.
If you get anywhere near 255 fields, you more than likely have a serious
design issue
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
G
Guest
A row in a table is a record. A record may have a maximum of 255 fields,
although if you are anywhere near that you may want to have another look at
your table design. The maximum field size depends on the data type you
select in table design view, and on the choices you make within that
framework. For instance, the default limit for a text field may be 50
characters, but you can have up to 255. See
Microsoft Access Specification in Help for more information.
although if you are anywhere near that you may want to have another look at
your table design. The maximum field size depends on the data type you
select in table design view, and on the choices you make within that
framework. For instance, the default limit for a text field may be 50
characters, but you can have up to 255. See
Microsoft Access Specification in Help for more information.
M
mcnewsxp
J
John Vinson
The most critical limitation is not the 255 fields (as noted
elsethread, no relational table should ever need anywhere near that
many fields) but the 2000 characters per record limit. If you have
(say) ten 255-byte Text fields, Access will let you create the table
and add data - but the moment a user tries to fill all ten fields to
their limit, they'll get an error.
Memo fields (which have their own limitations) aren't subject to this
limit; each memo adds 16 bytes to the 2000 count, regardless of the
size of its content.
John W. Vinson[MVP]