storage of null value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I am adding a table to my existing database that has a "Comment" field of
255 characters. Although very few "comments" have been added to the new
table, I believe it has resulted in the database growing from 4 meg to 6 meg.
I thought that Null values did not reserve storage space in the database.
Please enlighten me.

Please note: I want to maintain the one to many relationship I have with
another table, which will be the subject of the "comments."

Thank you for your assistance.
Captain OhNo
 
Captain said:
Hello,
I am adding a table to my existing database that has a "Comment"
field of 255 characters. Although very few "comments" have been
added to the new table, I believe it has resulted in the database
growing from 4 meg to 6 meg. I thought that Null values did not
reserve storage space in the database. Please enlighten me.

Please note: I want to maintain the one to many relationship I have
with another table, which will be the subject of the "comments."

Thank you for your assistance.
Captain OhNo
Click to expand...

Access text fields only use the space of actual data entered. Access files
do grow with use beyond data storage and this is completely normal.
Occassionally running the Compact/Repair operation will eliminate
accumulated "bloat".
 
Thanks for the info Rick. At least that eliminates the text field as the
cause of the 50% growth. Perhaps it was the addition of the table itself. I
Compact at least weekly. The growth rate was recorded after compacting.
Captain OhNo
 
Back
Top