Microsoft KB Archive/116144

= ACC2: Find Does Not Locate Existing Item in dBASE Database =

Article ID: 116144

Article Last Modified on 7/8/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



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.



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

-

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

© Microsoft Corporation. All rights reserved.