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:
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:
- Right-click in the grey space in the upper part of the query design grid, and then click Properties.
- Change the UniqueValues property to No.
- Click Totals on the Query Design toolbar to add a Total row to the query design grid.
- 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
- Open the sample database Northwind.mdb.
- Create a new query that is based on the Employees table and the Orders table.
- Include some of the fields from each table. Make sure that you include the Notes field from the Employees table (a Memo field).
- Right-click in the grey space in the upper part of the query design grid, and then click Properties.
- Change the UniqueValues property to Yes.
- 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.
Additional query words: pra
Keywords: kberrmsg kbbug kbpending KB303838