Microsoft KB Archive/149086

= ACC95: Duplicate AutoNumber Values Prevent Replication =

Article ID: 149086

Article Last Modified on 11/17/2000

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q149086



SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.

When an AutoNumber fields has duplicate values and you try to turn on the Replicable property of a local table in a replicated database, you may receive the following error message:

Duplicate value in index, primary key, or relationship. Changes were unsuccessful

-or-

When an AutoNumber fields has duplicate values and you try to create a replica of a database, you may receive the following error message:

Microsoft Access cannot convert the database to a Design Master. Cannot make the object in Tables container replicable.

NOTE: If a table contains an AutoNumber data type and cascading links and indexes that together total 32 or greater, this message will also be generated. The resolution for this alternate cause is to temporarily remove some of the cascading links and indexes prior to the conversion to Design Master and to restore the links after the conversion.



CAUSE
A field with the AutoNumber data type contains duplicate values. This can occur in AutoNumber fields whose NewValues property are either Increment or Random.



RESOLUTION
Because duplicate values defeat the purpose of the AutoNumber data type, you should ensure that the field does not contain duplicate values. If the field must contain duplicate values, you should specify a data type other than AutoNumber.



MORE INFORMATION
If a local table in a replicated database contains a field with an AutoNumber data type and the field contains duplicate values, the Replicable property of the table cannot be changed or the database cannot be converted into a Design Master.

