AutoNumber Field Duplicates Previous Values After You Compact and Repair a Database

The information in this article applies to:

CaseWizard 2000

Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS
After you compact and repair a database, you notice that when you enter new data, you notice the following error:

The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

RESOLUTION
Obtain Microsoft Jet 4.0 Service Pack 4 (SP4) or later, which contains an updated version of the Microsoft Jet 4.0 database engine.

For additional information about how to obtain the latest version of the Jet 4.0 database engine, click the article number below to view the article in the Microsoft Knowledge Base:

Q239114 ACC2000: Updated Version of Microsoft Jet 4.0 Available for Download

STATUS
Microsoft has confirmed this to be a problem in Microsoft Jet version 4.0.2927.4 and earlier.

Additional query words: pra sp4 identical same

877.926.8367 / 678.546.0018 / sales@casewizard.com

© 1998-2001 CyberDyne Industries, Inc.