Microsoft KB Archive/138443

= ACC95: How Replication Affects AutoNumber Fields =

Article ID: 138443

Article Last Modified on 11/17/2000

-

APPLIES TO


 * Microsoft Access 95 Standard Edition

-



This article was previously published under Q138443



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

When you convert a nonreplicable database to a replicated database, the AutoNumber fields in your tables change from incremental to random.



MORE INFORMATION
All existing AutoNumber fields in existing records retain their values, but new values for inserted records are random numbers. Random AutoNumber fields are not meaningful because they are not in any particular order and the record inserted last does not necessarily have the highest value.

When you open a table with a random AutoNumber key, the records appear in the order of ascending random numbers, not in chronological order. With random AutoNumber fields it is possible, although highly unlikely, for records inserted at different replicas to be assigned the same value. If this happens, updates could be made in the wrong records. If you experience such problems, consider using the s_Guid field as the primary key. Because all numbers in the s_Guid field are unique, each record has a different ID.

Before you convert your nonreplicable database into a replicated database, determine if any of your applications or users rely on the order and incremental nature of the AutoNumber field. If so, you can use an additional Date/Time field to provide sequential ordering information.

