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).
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]).
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:
239114To work around this problem, follow these steps:
(https://support.microsoft.com/kb/239114/ )How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
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.
This error does not occur when you use the UniqueRecords property.
Steps to Reproduce the Behavior
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.