The text data type has several inherent problems, including:
If you don't have to store more than 8KB of text, consider using char(8000) or varchar(8000) data types instead of text and ntext.
This tip and more found by Total SQL Analyzer PRO.
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.