We have an MS Access front end to a SQL Server 2000 database. One of the tables has a notes field, which according to our users is not large enough (it's currently the max # characters supported by varchar data type).
I've been asked to enlarge it, which means using Text data type. I'm wondering if there are any issues I need to be aware of before making this change. E.g., LEN doesn't work with Text, DATALENGTH has to be used instead.
Is there anything else? I've done some preliminary tests, and all seems to be ok, but I would like to be sure.
Thanks for any assistance with this,