You receive a "Cannot include Memo, OLE or Hyperlink Object when you select unique values" error message

Article translations Article translations
Article ID: 304431 - View products that this article applies to.
This article was previously published under Q304431
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

Expand all | Collapse all

On This Page

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 the latest Jet 4.0 service pack. For additional information about how to obtain and how to install the latest Jet 4.0 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
239114 How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
To work around this problem, follow these steps:
  1. Right-click in the grey space in the upper part of the query design grid, and then click Properties.
  2. Change the UniqueValues property to No.
  3. Click Totals on the Query Design toolbar to add a Total row to the query design grid.
  4. Make sure that the Total cell for each field is set to Group By.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in the latest Jet 4.0 service pack.

More information

This error does not occur when you use the UniqueRecords property.

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. Create a new query that is based on the Employees table and the Orders table.
  3. Include some of the fields from each table. Make sure that you include the Notes field from the Employees table (a Memo field).
  4. Right-click in the grey space in the upper part of the query design grid, and then click Properties.
  5. Change the UniqueValues property to Yes.
  6. Run the query on a computer that is running Jet 4.0 SP5. Note that you receive an error message similar to the error that is mentioned in the "Symptoms" section.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 304431 - Last Review: October 25, 2013 - Revision: 1.0
Applies to
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbnosurvey kbarchive kbprb kberrmsg kbpending KB304431

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com