ACC95: Duplicate AutoNumber Values Prevent Replication

ID: Q149086

The information in this article applies to:

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 <table name> 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.


REFERENCES

For more information about the AutoNumber data type, search for "AutoNumber," and then "Create a field that automatically generates numbers" using the Microsoft Access for Windows 95 Help Index. 


Keywords          : kbusage Rpldmr RplGen 
Version           : 7.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 27, 1999