Microsoft KB Archive/105513

From BetaArchive Wiki

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:

Record is too large.


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

  1. Using the sample database NWIND.MDB, create a new form called Form1 that is bound to the Employees table.
  2. Drag the Photo field to the form.
  3. From the View menu, choose Form.
  4. Leaving Form1 open, open the Employees form.
  5. From the Records menu, choose Edit Filter/Sort.
  6. Add the following line to the filter criteria:

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

    Record is too large

Additional query words: forms ole

Keywords: kberrmsg kbbug kbfix KB105513