Jumat, 19 April 2013

[MS_AccessPros] Re: The size of an Access database

 

Hi Ray,

The space defined for a Text field is not used until you
enter a value that nearly fills the defined allocation.

If your PostCode field is for the UK Only then it is OK
to have a 10byte field, probably with a format of '>'
and an Inputmask of '>CCCCCCCCCC' to force it to
uppercase.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "Ray" <rayfrew@...> wrote:
>
> I'm pondering about the amount of disc space a database takes and wondered if you could help. If I design tables with field sizes that should be just big enough for the data e.g. UK postcode as a 10 character text field, is that better than taking the default 50 characters? Does Access take the amount of disc space it needs to hold the actual data stored or does it reserve the whole amount as defined in the table definition?
>
> Any thoughts or pointer would be helpful.
> Thanks
> Ray
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar