Microsoft KB Archive/105513
Article ID: 105513
Article Last Modified on 5/6/2003
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
This article was previously published under Q105513
Advanced: Requires expert coding, interoperability, and multiuser skills.
Microsoft Access erroneously allows you to use OLE objects as filter criteria. If you attempt to do so, you may receive the following misleading error message:
Microsoft Access does not currently allow you to use OLE objects as filter criteria.
Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0, 1.1, and 2.0. This problem no longer occurs in Microsoft Access version 7.0; you can use Is Null or Not Null with the query by form (QBF) filter.
Steps to Reproduce Problem
- Using the sample database NWIND.MDB, create a new form called Form1 that is bound to the Employees table.
- Drag the Photo field to the form.
- From the View menu, choose Form.
- Leaving Form1 open, open the Employees form.
- From the Records menu, choose Edit Filter/Sort.
- Add the following line to the filter criteria:
Photo = Forms!Form1!Photo
- From the Records menu, choose Apply Filter/Sort. Note that you receive the following error message:
Additional query words: forms ole
Keywords: kberrmsg kbbug kbfix KB105513