Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/105513

From BetaArchive Wiki

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.

MORE INFORMATION

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