Table record size

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I've searched the groups trying to find the definitive
answer on how many characters can be stored in a single
record of a table in Access 2K.

Help says 2000, and this seems to be quoted in the
majority of threads I've seen.

So I ran a test. I created a new table added 20 or so 250
char fields, and proceeded to fill them with 240character
strings, expecting to get bounced on number 9.

It eventually gave up after 3956 characters in 17 fields.

Does anyone have the real oil?? I just hate looking silly
in front of customers
 
Hi Chris.
In Access 97 and earlier, the page size was 2048 bytes, but I think you had
to allow for the overhead associated with each field and the record itself.
In practice, then, slightly less than 2000 characters, though the exact
number depended on the table structure.

In Access 2000, that was doubled to cope with the fact that each character
now takes 2-bytes to store (Unicode). The exact number probably depends on
your code-page for your locale, and could even be affected by Unicode
Compression setting for your Text fields.

The fact that Help still says 2000 means only that it did not get updated.
 
Back
Top