ACC2002: Error When You Use Filter by Selection on a Data Access Page (295247)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295247
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you use filter by selection on a data access page, you receive the following error message:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

CAUSE

A key field in the underlying table has a space in its name.

RESOLUTION

Remove the space or spaces from the name of the key field.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

Steps to Reproduce the Behavior

  1. Start Microsoft Access, and then open the sample database Northwind.mdb.
  2. In the Database window, click the Customers table.
  3. On the Edit menu, click Copy.
  4. On the Edit menu, click Paste. When you are prompted, name the table CustomersSpace.
  5. Open the CustomersSpace table in Design view.
  6. Change the name of the CustomerID field to Customer ID, and then save and close the table.
  7. In the Database window, click Pages under Objects, and then click New.
  8. In the New Data Access Page dialog box, click AutoPage: Columnar, click the arrow in the Choose the table or query where the object's data comes from box, click CustomersSpace, and then click OK.
  9. When the page opens, click the Filter by Selection button on the navigation bar. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbbug kberrmsg kbnofix KB295247
©2004 Microsoft Corporation. All rights reserved.