Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Access memory buffers

    "When a field in Access is declared to 255 characters for a text field,
    are memory buffers of 255 bytes created for that table when it is opened? Is there any real advantage to truncating the text fields to a smaller size than 255, or is there potential for memory overusage if all text fields are set to 255?"

  2. #2
    Join Date
    Sep 2003
    Caldes de Malavella, Spain

    Re: Access memory buffers

    No. Access text fields are variable length, and the buffers are created dynamically depending on the contents of the field in a particular record. The whole purpose of setting a text field to a value less than 255 is to restrict the amount of text that can be entered into it.
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy

Posting Permissions

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