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 am concerned about something.
>
>I have to add a memo field to a table that already has 3 memo fields. The table is now about 300,000 records and will probably grow to a million. I am concerned that the table might become susceptible to corruption having too many memo fields.
>
>Is my concern justifiable?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"