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

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.

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.
On the View menu, click Page View.
Click in the CategoryID box.
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"
					
```
Press ALT+F11 to toggle back to Microsoft Access.
Click the Apply Filter button on the Navigation Bar.

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