Microsoft KB Archive/105513

= ACC: OLE Objects Seem to Be Acceptable Filter Criteria =

Article ID: 105513

Article Last Modified on 5/6/2003

-

APPLIES TO


 * 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





SYMPTOMS
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:

Record is too large.



CAUSE
Microsoft Access does not currently allow you to use OLE objects as filter criteria.



STATUS
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.</li> Add the following line to the filter criteria:

Photo = Forms!Form1!Photo</li> From the Records menu, choose Apply Filter/Sort. Note that you receive the following error message:

Record is too large

</li></ol>

Additional query words: forms ole

Keywords: kberrmsg kbbug kbfix KB105513

-

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

© Microsoft Corporation. All rights reserved.