Are rows stored in fixed or variable length records.

[Dennis]

Hi,

This is just a point of curiosity for me. I realize that Access works the
Access works.

Does any one know if the rows are stored in the database as fix length
record or as variable length records?

 

[Jeff Boyce]

Dennis

Second-hand, take w/ salt ...

Access fields are variable length, consuming as much space as is needed for
the data contained therein. My hunch is this makes the records variable
length as well.

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Jerry Whittle]

Variable. If you make a text field size of 255, but only put in 4 characters,
it only uses 4 characters of space.

However don't make everything 255 characters as the wizards look at that
value when creating text boxes on your forms and reports.

 

[Dennis]

Jeff, Jerry,

Thanks for the info and the educationl.

Dennis