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

    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
    Location
    Caldes de Malavella, Spain
    Posts
    244

    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
    http://www.elmhurstsolutions.com

Posting Permissions

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