Microsoft KB Archive/223236

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

Article ID: 223236

Article Last Modified on 6/30/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q223236



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 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 (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:

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 that this is a problem in Access.



Steps to Reproduce Behavior
 Start Microsoft Access and open the sample database, Northwind.mdb. In the Database window, click Pages under Objects, and then click Create data access page in Design view. On the View menu, click Field List. 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. Under the Categories table, click CategoryID, and then click Add to Page.</li> On the View menu, click Page View.</li> Click in the CategoryID box.</li>  Press CTRL+G to open the Immediate Window. Type the following line in the Immediate window, and then press ENTER: dataaccesspages(0).Document.msodsc.currentsection.datapage.filter = "CategoryID LIKE NULL" </li> Press ALT+F11 to toggle back to Microsoft Access.</li> Click the Apply Filter button on the Navigation Bar.</li></ol>

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

Additional query words: pra Access caused an invalid page fault in MSADO15 DLL

Keywords: kbbug kbdap kbpending KB223236

-

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

© Microsoft Corporation. All rights reserved.