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

4k Table limit

P: n/a
ken
Hi,
I was wondering how the 4k table record limit is counted. I have access
2k. I text fields are 256 chars. Memo fields are not included in the
calculation. What about yes/no fields would that be just 1 char? also
integers they are probably not included either?

I just need to make sure none of my tables exceeds the limit.

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Not sure where you got that "4k" table limit in Access. Access 97-2003
limits each data table to 255 fields, and each field (except memos -64k) to
255 characters.

BTW, no well designed database will have a table anywhere approaching those
limits.
-Ed

"ken" <ge****@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Hi,
I was wondering how the 4k table record limit is counted. I have access
2k. I text fields are 256 chars. Memo fields are not included in the
calculation. What about yes/no fields would that be just 1 char? also
integers they are probably not included either?

I just need to make sure none of my tables exceeds the limit.

Thanks

Nov 13 '05 #2

P: n/a
Ed Robichaud wrote:
Not sure where you got that "4k" table limit in Access. Access 97-2003
limits each data table to 255 fields, and each field (except memos -64k) to
255 characters.


Text fields are variable length, there is still a storage limit for the
entire record, not sure what it is, prolly 4K like the OP says.

--
[OO=00=OO]
Nov 13 '05 #3

P: n/a
Right you are. I should have remembered the unicode limit.
Here are the official MS specs for Access tables:

Maximums--
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048; the actual number may be less because of tables
opened internally by Microsoft Access
Table size 2 gigabyte minus the space needed for the system objects
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the
user interface;
1 gigabyte of character storage when entering data programmatically
Size of an OLE Object field 1 gigabyte
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes 4,000
Number of characters in a field property setting 255

-Ed

"Trevor Best" <no****@besty.org.uk> wrote in message
news:42**********************@news.zen.co.uk...
Ed Robichaud wrote:
Not sure where you got that "4k" table limit in Access. Access 97-2003
limits each data table to 255 fields, and each field (except memos -64k)
to 255 characters.


Text fields are variable length, there is still a storage limit for the
entire record, not sure what it is, prolly 4K like the OP says.

--
[OO=00=OO]

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.