ACC95: Duplicate AutoNumber Values Prevent Replication

 Last reviewed: May 23, 1997
Article ID: Q149086
The information in this article applies to:
  • Microsoft Access version 7.0

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
Hardware : X86
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 23, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.