I know this isn't much of a real issue, but I'm confused about the need, or not, to adjust the Field Size property in a table. I've read about this, but all I seem to get is conflicting opinions.
Originally I thought I should adjust the field size to best match the data that will reside in the field. I did this because I thought that it would reduce the size of the Access file as well as make it more efficient in storing the data. Then I read that it doesn't make any difference if a change the default 255 to a lower number because Access dynamically creates the necessary space and it doesn't increase the overall file size. (Maybe this was more of an issue in earlier versions of Access.)
Can anyone offer anything approaching a definitive answer to this mini-dilemma? Does it matter? If not, are there still good reasons to adjust the field size property to a number lower than the default?
[Non-text portions of this message have been removed]
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar