if SELECT DISTINCT is specified, or if the SELECT statement contains a UNION operator, the sort columns must appear in the select list.

ACC2000: Error Message: Run-Time Error '3114' : Cannot Include Memo, OLE or 
Hyperlink Object When You Select Unique Values
SYMPTOMS
When you run a query that includes a Memo, an OLE, or a Hyperlink field on a 
computer that is running Microsoft Jet  4 . 0  Service Pack  5  (SP5), you receive the 
following error message: 
Run-time error '3114':

Cannot include Memo, OLE or Hyperlink Object when you select unique values 
([tablename].[fieldname]). 

RESOLUTION
To resolve this problem, install Jet  4 . 0  Service Pack  6  (SP6).

 257408  ACC2000: AutoNumber Field Duplicates Previous Values After You Compact and Repair a Database 
 248907  ACC2000: Append Query on Linked Tables Adds Incorrect GUID Values 
 254845  ACC2000: Memo Field Characters Are Displayed as Question Marks 
 250637  FIX: Jet  4 . 0  Creates Incorrect CREATE TABLE Statements 
 257414  ACC2000: Result of the Mid, the Left, or the Right Function in Query Referring to Memo Column Is Incorrect 
 257487  ACC2000: Access Displays #DELETED When You Insert Data with the Same Value into a Non-Unique Key Column of a Remote Table 
 282604  ACC2000: Microsoft Jet Does Not Pass WHERE Clause to ODBC Data Source 
 297355  Error Message  "Incorrect Syntax Near ',' (#170 )" with a Comma as a Decimal Separator 
 311159  FIX: Inefficient Use of LIKE Clause with Jet OLEDB Provider