ACC2000: IPF in MSADO15.DLL Clicking Apply Filter Button with a Filter in a Data Access Page

ID: Q223236

The information in this article applies to:
Moderate: Requires basic macro, coding, and interoperability skills.

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


SYMPTOMS

When you use a data access page that has a filter that use Null, you receive the following error message:

This program has performed an illegal operation and will be shut down.

If the problem persists, contact the program vendor.
When you click Details, the following message appears:
Access caused an invalid page fault in MSADO15.DLL at 015f:1f341e8c.
NOTE: The actual memory address may vary.


CAUSE

The LIKE operator is not expecting Null as a possible value. It expects only strings. Null is allowed only with the = or <> operators.


STATUS

Microsoft has confirmed this to be a problem in Access.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Start Microsoft Access and open the sample database, Northwind.mdb.


  2. In the Database window, click Pages under Objects, and then click Create data access page in Design view.


  3. On the View menu, click Field List.


  4. In the Field List dialog box, click the plus sign next to Tables to expand the list, and then click the plus sign next to Categories.


  5. Under the Categories table, click CategoryID , and then click Add to Page.


  6. On the View menu, click Page View.


  7. Click in the CategoryID box.


  8. Press CTRL+G to open the Immediate Window.


    9. Type the following line in the Immediate window, and then press ENTER: 
    
dataaccesspages(0).Document.msodsc.currentsection.datapage.filter = "CategoryID LIKE NULL"
  9. Press ALT+F11 to toggle back to Microsoft Access.


  10. Click the Apply Filter button on the Navigation Bar.


Note that you receive the error mentioned in the "Symptoms" section of this article.

Additional query words: pra 


Keywords          : kbdta DAPProb 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 13, 1999