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

When you use a data access page that has a filter that use Null, you receive the following error message: When you click Details (on Microsoft Windows Millennium Edition, press ALT+D), you receive the following message:
NOTE: The actual memory address may vary.

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

Microsoft has confirmed that this is a problem in Access.

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. 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.