Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: Ms Access Data Length Constraint

    Hi,
    I have got a chnace to rectify a legacy system build around MS Access. The issue is, one of the field is not inserting the data from the application as the datatype defind for the field in the access is TEXT. And TEXT column can store only upto 255 character. There is one option to define the data type as MEMO. But have 2 issues in that case....

    1: What will happen to the exiting data.
    2: Will the colum occupies the total allocated character size of 63699 character? If that is the case then, the data base file (access) size will increase like any thing.

    Kinldy suggest for the best approach.


    Thanks,
    Rahul Jha

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Memo is still variable length. It should not affect the existing data.

    I would suggest, though, that 5 minutes of testing on a copy of the data would put your mind at ease.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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