Knowledge Base

ACC2: Find Does Not Locate Existing Item in dBASE Database

Article ID: 116144

Article Last Modified on 7/8/2002

APPLIES TO

This article was previously published under Q116144
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you search for a string in an attached dBASE database, the string is not found, even though the string does exist in the dBASE database.

CAUSE

This problem only occurs if you search for the string in the attached database using the wrong case and without selecting the Match Case check box first.

RESOLUTION

In the Find dialog box, select and then clear the Match Case check box before choosing either of the Find buttons.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.

MORE INFORMATION

Steps to Reproduce Problem


  1. Start Microsoft Access and open any database.
  2. From the File menu, choose Attach. In the Data Source box, select dBASE IV, then choose OK. In the File Name box, select the dBASE IV database file NEWCUST.DBF, then choose Attach. (The NEWCUST.DBF file is usually located in the SAMPAPPS subdirectory.) In the Select Index Files dialog box, choose Close. Choose OK when you get a message stating "Successfully attached 'NEWCUST'. Choose Close.
  3. Open the NEWCUST table in Datasheet view.
  4. Select the CITY column.
  5. From the Edit menu, choose Find.
  6. In the Find What box, type portland and then choose Find First. Note that no string is found.
  7. Select the Match Case check box and then choose Find First. Note that no string is found.
  8. Clear the Match Case check box and choose Find First. Note that the first "Portland" text string is found.
dBASE IV is manufactured by Borland International, Inc., a vendor independent of Microsoft; we make no warranty, implied or otherwise, regarding this product's performance or reliability.

Additional query words: lowercase

Keywords: kbbug kb3rdparty KB116144


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.