ACC2000: Duplicate Records in dBASE IV File Appear to Be Missing (208956)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q208956
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

If you create a link to a dBASE IV file without selecting an index file, some of the data in the dBASE IV file may appear to be missing when you open the linked table in Datasheet view.

CAUSE

You may be using a dBASE IV index file whose Display First Duplicate Key Only setting is turned on. This dBASE IV setting causes records with duplicate primary key values to be hidden.

RESOLUTION

Make sure that you specify an index that displays all records in dBASE IV, and make sure that you select the appropriate index file when you link the dBASE IV file in Microsoft Access.

MORE INFORMATION

When you link a dBASE IV file, you are prompted to select an index file. If you do not select an index file, Microsoft Access selects one for you. When Microsoft Access selects an index file for you, it first looks for an index file with the same name as the data file that you are linking. If it cannot find such a file, Microsoft Access looks for the most recently created or the most recently changed index file.

When you let Microsoft Access select the index file for you, you are taking a chance that Access will select an index file whose Display First Duplicate Key Only setting is turned on. If Access selects such an index file, any record in the data file with a duplicate primary key value will be hidden automatically.

After a primary index file is selected, the only way to use a different index is to delete the link in Microsoft Access, and then to relink the table.

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.

REFERENCES

For more information about attaching dBASE IV files, click Microsoft Access Help on the Help menu, type dBASE files in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbinterop kbprb KB208956
©2004 Microsoft Corporation. All rights reserved.