|
|
||||||
|
#1
02-09-10, 02:09 PM
|
|
|
|
|
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? |
|
|
|
#2
02-09-10, 03:01 PM
|
|
|
|
|
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. |
|
#3
02-09-10, 03:23 PM
|
|
|
|
|
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. |
|
#4
02-14-10, 06:13 AM
|
|
|
|
|
Jeff, Jerry,
Thanks for the info and the educationl. Dennis |
|
|
| Similar Threads | |
| Does Access store its data in fixed length or variable length rows
|
|
| fixed or variable character length Hello all, I am currently using HP Fortran 90 compiler and I have a quick question that has been bugging me for a bit. I am trying to create a file name the following... |
|
| Fixed length records containing 2 different records types with fixed field widths This is a fun one. I am beginning to receive fixed length record ASCII files but they contain 2 different record types. - All records are 290 in length but have different... |
|
| reading variable and fixed length records I'm trying to read a file with records of the form: [byteA][byteB]...[byteN][0][byte1][byte2][byte3] i.e. an initial variable length part; a zero marker; then a fixed... |
|
| Import of Variable Length Lines With Fixed Length Fields I'm using a fixed length fields in a DTS package to import a text file. Each line in the text file ends with a CR\LF delimiter. The lines do not all have the same length. ... |
|
|
All times are GMT. The time now is 11:59 AM. | Privacy Policy
|
Are rows stored in fixed or variable length records.