Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    6

    Unanswered: Text Field Character Limit

    Hi

    I have an application that I have been considering to port to another database because of the 255 character limitation of MS Access for the text field.

    My 1st choice was SQL Server but I was told that you can't connect to the datafile that it uses without having the server installed. Then someone in one of the other forums said that Access can store more than 255 characters and to ask around in the MS Access forums.

    From the issues I have been having, I don't believe that you can store more than 255 characters in a Text field. Can anyone confirm this?

    I'll also gladly entertain any suggestions for another database platform that has the portability of Access but is more robust.

    I've tried using the memo field to store the data but it doesn't seem to work. The data I'm trying to add to the field can be either a directory path or URL.

    Anyone have some suggestions to help me out???

    thx

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Check out the Memo data type in Access. It allows you to store 64,000 characters in one field.

    The memo data type does work! I have loads of databases with URLs and such stored in memos. As long as compact and repair is done regularly, then there are really no issues.

    The only downside to a memo field is they cannot be sorted or indexed.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    memo should work, however IIRC you can't index on a memo, and Im not too sure if you can use a memo column in a where clause. but 255 character in a URL or path seesm mad... that'd be where I'd be wanting to look. If paths start to get more than 70....100 characters I'd want to know why, thats a heck of a lot of characters to type in.. or maybe Im still to wedded to DOS & 8.3 filenames....
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No, a 255 character URL is a long one.

    This is a bogus one that is exactly 255 characters long:

    http:/www.cypherbyte.com.au/access-training-introduction/tables/design/bringingthemagic/omgthisisalongurl/imeanwhatwouldbesolong/lol/wtfbbq/andistillhave50togo/ummm/normalisationisimportant/whatnext/whattheheckisthisthingcalledrelationships.php?sect ion=10

    255 is plenty, but Memo still works if you need it.

    And you can include a memo in a where clause.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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