Microsoft KB Archive/303838

= ACC2000: Error Message: Run-Time Error '3114' : Cannot Include Memo, OLE or Hyperlink Object When You Select Unique Values =

Article ID: 303838

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q303838



Moderate: Requires basic macro, coding, and interoperability skills.

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



For a Microsoft Access 2002 version of this article, see 304431.



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 ([ ].[ ]).



RESOLUTION
This problem is fixed in Jet 4.0 Service Pack 6 (SP6) and later. For additional information about how to obtain 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 fixed in Jet 4.0 Service Pack 6 (SP6).



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 &quot;Symptoms&quot; section.

Additional query words: pra

Keywords: kberrmsg kbbug kbpending KB303838

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.