When you use the Mid
, the Left
, or the Right
string function in a query to parse a column of data type Memo that contains a string that is longer than 256 characters, the result may be truncated.
This problem has been fixed in the latest edition of the Jet Service Pack.
For additional information about how to obtain the latest version of the Jet 4.0 database engine, click the following article number to view the article in the Microsoft Knowledge Base:
How to obtain the latest service pack for the Microsoft Jet 4.0 Database Engine
Microsoft has confirmed this to be a problem in Microsoft Jet version 4.0.2927.4 and earlier.