>Anything is possible - I would be more concerned about exceeding the 2GB limit. Perhaps a new linked table with only the new memo field and the key fields?
>
I thought about it. But since almost each and every record will have an entry to the new memo field, I sort of dismissed this idea. But when I think about it now, after reading your message, putting the new memo field into a separate table will not save space but will minimize the possibility of the 2 Gb limit and data corruption. The downside, of course, is so much extra work to "link" the table in each and every query. Something to think about.
Thank you for your suggestion.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
