About AutoNumber field size and replicated databases (MDB)

 Note   The information in this topic applies only to a Microsoft Access database (.mdb).

If you plan to replicate (replication: The process of copying a database so that two or more copies can exchange updates of data or replicated objects. This exchange is called synchronization.) your database, you need to consider what field size is appropriate for the AutoNumber field used as a table's primary key (primary key: One or more fields (columns) whose values uniquely identify each record in a table. A primary key cannot allow Null values and must always have a unique index. A primary key is used to relate a table to foreign keys in other tables.). If you use an AutoNumber field as the primary key for a table in the replicated database, set its FieldSize property to either Long Integer or Replication ID.

 
 
Applies to:
Access 2003