ACC95: Duplicate AutoNumber Values Prevent Replication (149086)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
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 <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.
| Modification Type: | Major | Last Reviewed: | 11/17/2000 |
|---|
| Keywords: | kbprb kbusage KB149086 |
|---|
|