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.