Results 1 to 4 of 4

Thread: Use of memory

  1. #1
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Use of memory

    When I have a text field defined with a field length of 200.
    Then I suppose that Access will reserve this length in the memory even if I only use 10 positions.

    Is this correct. If not could someone explane to me how Access usses the memory?

    Thanks in advance.
    Greetings,

    Patrick Schouten
    (The Netherlands)

  2. #2
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Gillingham, Kent, England
    Posts
    511
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use of memory

    I was under the impression that Access lets you define the field length for reasons such as e.g. 50 characters fits in a window envelope in a mailmerge, so the field can't be more that 50 characters long. Where memory is concerned, I had always assumed that Access assigned memory as you typed, and wrote the information to hard disk when you clicked the save record button. I may be wrong, as I do not know this for a fact. Interesting question though and I hope you get a definite answer.

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use of memory

    When you say "memory", do you mean disk space?

    I'm not quite sure of the specifics, but I believe Access stores a value of 10 characters and 190 blank spaces in your case of a 200 character text field. This is why data type and field length are very important to optimizing a database.

    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Lewes, East Sussex, Sussex, United Kingdom
    Posts
    232
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Use of memory

    I thought that Access only stored the actual number of characters in the text field. The actual length of the field is stored as a 1-byte overhead. So the maximum length is an indicator only.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •